Session Problem in BODS

[system]

120×120 10.4 KB

Okay, then I support the suggestion to increase the number of session and processes in your source/target database. alter system set processes=500 scope=spfile; alter system set sessions=800 scope=spfile; and then restart the database. Also, you might want to think about reducing the number of partitions, 70 is quite high unless you have 500CPUs. Simply open the table from the object library, go to the partition and remove every second partition or so. Then DS will not execute a select * f…

120×120 10.4 KB

Hi, My DI job fails to run in new test environment and works fine in dev .pls suggest me to fix this issue. DI version 11.7 running on a Windows 2003 Sever 64-bit. Oracle 10g (source and target database) running on HP Unix Server 64-bit. Encountering the following oracle error approximately mid way through the DI batch job load: (11.7) 12-05-08 14:35:24 (E) (4268:4064) CON-120404: |Dataflow DF_MIDAS_F_QUERIES_CREATED OCI call for connection failed: . (11.7) 12-05-08 14:35:28 (E) (4180:1940…

120×120 10.4 KB

Has anyone experienced the following error? Dataflow DF_XYZ OCI call for connection failed: <ORA-12537: TNS:connection closed>. This is against a source DB where, from what we have been told, no changes have occured. Some of the DF were successful… We just re-created a job with only this DF and it worked. Now we are re-running the whole Job again. I was also seeing the above issues when attempting to change a DataStore connection (Host, ID, PWD) in Development… cduey (BOB me…

---

Werner Daehn (BOB member since 2004-12-17)