COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: larus on 31 Aug 2012 07:28:05 AM

Title: Error when querying data from SAP R/3
Post by: larus on 31 Aug 2012 07:28:05 AM
I'm trying to connect to SAP ERP system using SAP R/3 connector. I getting the following error when running query to SQL Term:

1. ERROR
DM-DBM-0400 UDA driver reported the following on connection SAP system:

UDA-SQL-0107 A general exception has occurred during the operation "Operating system cannot close file /tmp/COMPUTER00030650000001.TMP SYSTEM_FAILURE".

UDA-SQL-0196 The table or view "T005" was not found in the dictionary.


Any ideas what might cause this problem?


Title: Re: Error when querying data from SAP R/3
Post by: larus on 03 Sep 2012 07:46:38 AM
I found this, there was a problem with execute rights on a SAP Server:

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14410268

Title: Re: Error when querying data from SAP R/3
Post by: MFGF on 03 Sep 2012 10:18:58 AM
Thanks for the update! Glad you managed to fix the issue :)

MF.