07-30-2024 09:24 PM
Hi to the OneStream Comunity.
Im having some issues since the IT outage that happened a weeks ago.
In this case I have been using the a ODBC connector to pull from Netsuite a failry simple query to pull the Trail balalnce for all accounts. This since July 19th going foward is failing giving me this error:
Summary: Unable to execute Business Rule 'SQL_NetSuite_TB'. Smart Integration Connector remote query failed. One or more errors occurred. (A task was canceled.)
One or more errors occurred. (A task was canceled.)
A task was canceled.
Im assuming is a time out issues in the Netsuite side. Still working with them to figure out.
Thanks in advance for your reply.
Solved! Go to Solution.
08-14-2024 12:53 PM
Hi Joakim,
Oracle was involved and magically the issue was not replicable, netiher I could replicated again when asked to send them new logs. So Im assuming there was some issue with their server becouse of the world IT outage problem. The issue did appear on moday after the world outage, Im assuming was that, and it was not fixed until enough tickets raised to oracle.
08-13-2024 11:04 AM
This is very difficult to answer without diving a little deeper into the issue. I would suggest you log a ticket with our support team to look into this.
In the meantime, could you do a quick test by creating a Data Adapter (in the Workspace sections as a component inside a maintenance unit), point that data adapter to the same connection and run a super small test query (equivalent of "Select Top 10 * from <tablename>" and see if that works?
08-14-2024 12:53 PM
Hi Joakim,
Oracle was involved and magically the issue was not replicable, netiher I could replicated again when asked to send them new logs. So Im assuming there was some issue with their server becouse of the world IT outage problem. The issue did appear on moday after the world outage, Im assuming was that, and it was not fixed until enough tickets raised to oracle.