DSXchange

Have a very similar issue. Installed the 12c client version to use with 12c dbase. Could get round it by creating symbolic link from the libraries that cannot be found, to the 12c equivalent libraries. Did some more digging however and it seems that IBM only support upto 11gR2 client version with 12...

One other thing to note as well is that we now seem to be seeing the deadlock daemon log file (dsdlockd.log) constantly bee updated which we had not had before. I have been searching for this and this seems to happen when certain files that should be owned by root are not. This does not however appe...

Apologies - I checked them against a sister environment where this issue does not seem to occur and they matched.

Thanks for the suggestions but the issue does not seem to be related to these. I attempted to recreate the problem on another environment (same OS, DS version etc) but was no issue here. The only difference was on the MEMOFF settings which were ... DMEMOFF = 0x0 PMEMOFF = 0x0 CMEMOFF = 0x0 NMEMOFF =...

This is a new environment (migration from 8.1 and aix) although we have migrated several other similar applications to linux 9.1 and without issue. We have a very simple script that is resetting and firing off DS multi instance jobs which is causing a few problems. I have stripped down and recreated...

Hi Arnd,

Yes - well used 'strace'. The java process was timing out in attempting to connect and turned out to be a problem with a mount point.

Thanks.

Doing an Install of 9.1 and running a check/test on the ResponseFile.txt created with the following .... ${gc_InstallationSourceDir}/setup -rsp /iis/InstTmp/ResponseFile.txt \ -reportFile /iis/InstTmp/ReportFile.txt \ -reportOnly The following pid is launched ... _jvm/bin/java -Dlauncher.usage.strin...

First thing to say is that my job actually successfully completes and loads my teradata table as expected. When however I try to 'view data' from within the stage itself I get the following error .. ..DbaseLoad: Object 'TableListNotExist' does not exist. : RDBMS Code 3807 ..DbaseLoad.DSLink1: DSP.Op...

Many thanks - the 8.5 doc makes it pretty clear that you have to specify an asc/dsc option.

I have a server job with a sort stage (already advised owners to move to a unix sort) which fails with the following error when Asc/Dsc not set ... Internal Error: sort specification error, function create_sort_spec returned [DSTAGE-SORT-0059`:`Invalid sort specification] Is there not a default opti...

Have checked with the DBA's and they tell me there is no sign of corruption whatsoever.

Any other ideas?

chulett wrote:You don't have to have your database on the ETL server to use Automatic loading from what I recall.

And you need to take your error to your DBA - you may have disk errors / corrupted blocks and th ...

Thanks for that - will do so.

Having a problem with Oracle OCI Load Stage - a simple but new job loading a couple of rows ... T00014_Srv_Oracle_OCI_Load..DbaseLoad: ORA-24795: Illegal COMMIT attempt made DSTAGE-ORAOCIBL-0001`:`Internal Error: Load database failed. ORA-01114: IO error writing block to file (block # ) I am using '...

Seems the SP was created in a different session mode to what I had in the stage. Though now have a different error ...

RDBMS code 3514: User-generated transaction ABORT.

The settings in the job are ... procedure type = source DB proc type = SP Generate procedure call is checked The SP itself is ... CREATE PROCEDURE TEST1 ( OUT CduCin BIGINT ) BEGIN SELECT FIELD1 INTO CduCin FROM TABLE1 WHERE FIELD1 = 1; END; I have posted on the dbase side as well. Thanks & Rega...