Report Generation through Workflow Fails at the Second Attempt with SBL-DAT-00407 and SBL-DAT-00393 error (Doc ID 2021027.1)

Last updated on DECEMBER 01, 2016

Applies to:

Siebel eCommunications - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11 [23030] version, Reports

When executing a report through custom Workflow, it works fine at the first attempt but fails at the subsequent attempts with the error:

ERROR
-----------------------

-> In Siebel UI, the following error is received:
SBL-BPR-00162 Error when invoking the service ' Service ', XMLP Driver method ' GenerateBIPReport ' in step ' Generate Report '.

-> In Siebel application log, the following is verified:
SBL-DAT-00407: A operação não é permitida no objeto de SQL no modo de avanço somente.
[0] Ocorreu um erro de fim de arquivo.
Continue ou peça ao administrador do sistema para verificar a configuração do seu aplicativo, se o problema persistir.(SBL-DAT-00393) (0x750189)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run report through custom Workflow successfully
2. Still in the same session, re-execute the same report and it fails with SBL-BPR-00162. If users logs off and logs in again, the report can be executed.



Changes

Issue has been found after upgrading to 8.1.1.11.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms