Everything was fine, but days ago, sometimes i started to receive this error
This happens 'sometimes' when i leave a job scheduled and it tries to connect to a MS SQL Server database (with Oracle/Sybase there is no problem since i use the oci stage and sybase oc and oracle client).df_carga_tbaccounting_detail..HHD_TST_A_SALFGD.IDENT1.de_sqltst_a_salfgd: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT ACCNT_CODE,TRANS_DATETIME,D_C
,case when isnumeric(TREFERENCE)=1 then (TREFERENCE) else '0' end
, ENTRY_DATETIME
,CONV_CODE,OTHER_AMT,ANAL_T0, BASE_RATE, DESCR, LOOKUP, JRNAL_NO, JRNAL_LINE
FROM SUNDB5..CO1_ACNT,
SUNDB5..CO1_A_SALFLDG WHERE
ACNT_CODE = ACCNT_CODE and TRANS_DATETIME = "20061222"
SQLSTATE=HY000, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]The DataDirect ODBC driver you are attempting to access has been provided to you by Ascential Software for exclusive use with Ascential Data Integration Suite. You are not licensed to use this driver with any application other than Ascential Data Integration Suite. If you would like to purchase a driver for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com
We a full license here, 999 users, no expiration date, everything good.
But that error is very weird. I have search on different topics in this forum, but i had no luck.
please if someone can give a hand if its a OS problem, DS problem, if i need to purchase something else from Ascential??
Thanks in advance
Regards,
Diego.