DSXchange

Thx Ernie, It appears if I import metadata for any table from a specific schema and include primary keys, the import fails as mentioned in original post. If I import the metadata for the same table, but don't include primary keys, import works. If I import metadata from any table in any other schema...

I'm waiting for Ernie's thoughts.

:D

In the import process you can specify(via a checkbox) whether or not to include primary keys. On previous imports, we checked this box. I found I am able to now import metadata if I leave this box unchecked. Which leads me to believe that there is still a reference to the primary key in the reposito...

In looking further at the stack trace I see the following: Caused by: com.ibm.xmeta.datamgmt.exception.CommonBaseException: 1 problem(s) occurred during asset import. 1. com.ascential.xmeta.exception.data.DuplicateImportIdentityException: two imported objects of type "http:///4.0/ASCLModel.ecor...

Hello Everyone, I am currently importing metadata into datastage using the 'connector import wizard' with an Oracle connector. When I try and import the metadata from a table, I get the error message(An unexpected exception occurred accessing the repository: ) as well as: <JavaException><Type>com/as...

Try:

DateFromJulianDay(JulianDayFromDate(CurrentDate()) - 1)

Good to know what 'Updatable lookup' refers to. thx Found the issue. Even though I explicitly defined the sorts on my input links, DS wanted to do it's own internal sort in the scd stage. We had the environment variable($APT_NO_SORT_INSERTION) set to 'True', not allowing DS to insert sorts(thus the ...

Hello Everyone, I created an scd job for an Oracle dimension table. When the job is set up as a type 1 scd, everything runs great. When I change it to a type 2 scd, the job aborts with the following message: scd_dw_dim,0: Fatal Error: Updatable lookup requires sorted keys. Both of my inputs are hash...

The copy solution also works, as mentioned by Kumar. I haven't seen a solution that allows the capture of the sqlcode though.

thx

:D

I have this same issue when I drop a reject link off my odbc stage. I have to pass a dummy column(sqlcode) to the odbc stage. Otherwise I get the error "could not find input field sqlcode" in odbc stage. When I do this my dummy value overwrites any sqlcode that may be generated in the reje...

The interesting thing is that even if I define an invalid table in my odbc sql server stage, the job log captures the fatal messages, but the job doesn't abort.

We are updating our sql server odbc driver to see if that makes a difference.

thx

Running job to load records into sql server 2008 table. One record is bad, causing the following fatal error in job log: ODBC_INSERT_TABLE,0: [DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification <message type is fatal> Job doesn't abort, but finishes with warnings. Any ...

Yes. I opened each message in it's own window and used Next to get to next message. All warnings are the same. Also the data is static. One thing that occured to me was that maybe a time component of a timestamp was changing each time I ran, but the date is not derived, it is a static value. This da...

Hello All, I am loading a sql server table with 8000 records. A unique index exists on this table(based on 4 columns). When I load the same 8000 records again(with no limit on warnings), only 46 warning messages appear in the log: (ODBC_INSERT_TABLE_STG,0: [DataDirect][ODBC SQL Server Driver][SQL Se...

Sorry, that was my faux pas. I originally typed in the results adding a space to make it clearer.

thx