If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DB2 Load Issue with Data Manager

Started by abzmanc, 15 Sep 2009 07:10:40 AM

Previous topic - Next topic

abzmanc

Hi All, new guy here, got a query RE Data Manager.

DBA has set up a database for us, now im creating Fact and Dimension Builds within Data Manager. I can run the Dimension Build Jobs just fine and the tables will be created/populated. When I do this with the Fact Build the Table is created but will not populate, it gives me the following error...


-----Delivery 'F_Problem_Ticket': DB2 LOAD Output file-----

   Database Connection Information

Database server        = DB2/LINUXX8664 9.5.4

SQL authorization ID   = COG_ADM

Local database alias   = STAR_DB

SQL3025N  A parameter specifying a filename or path is not valid.
-----------------------------------------------------------

DM-D2L-0060 The delivery 'F_Problem_Ticket': DB2 LOAD process failed (status 4).

DM-BLD-0005 The delivery 'F_Problem_Ticket' failed.


[PROGRESS   - 13:03:51] Build 'F_Problem_Ticket' Failed
databuild -- failed (15-Sep-2009 13:03:51)



Anybody here come across something similar before?? Have no idea what to do, DBA doesnt have an immediate solution either.