Error "failed to submit record" during Run logic package execution

[romuald_colletaz]

Hello,

we use the Run logic package to execute a script according to the content of a loaded fle. We use the "Execute formula on region in data file" option to do so. t works fine in development environment.

In the test environment the "failed to submit record" error is raised.

any ideas?

Romuald

Here is an overview of the formula log file:

****************************************************************************************************

Start time --->6:02:39 PM - Date:4/9/2009 (build code:254)

****************************************************************************************************

User:EU\svc_sapbpc_sysadmin

Appset:BUDGET_TOOL

App:BUDGET

Logic mode:1

Logic by:

Scope by:CATEGORY,TIME,ENTITY

Data File:D:\Data\WebFolders\BUDGET_TOOL\BUDGET\PrivatePublications\svc_sapbpc_sysadmin\TempFiles\2009-04-09-160148-UpletList-Import_SAP_ACTUAL_1T2009.txt

Debug File:D:\Data\Webfolders\BUDGET_TOOL\BUDGET\PrivatePublications\svc_sapbpc_sysadmin\TempFiles
DebugLogic_1760_.Log

Logic File:D:\Data\Webfolders\BUDGET_TOOL\ADMINAPP\BUDGET\FXTrans.LGX

Selection:

Run mode:0

Query size:0

Delim:;

Query type:0

Simulation:0

Calc diff.:0

Formula script:

Max Members:

Test mode:0

Is Modelling:1

Number of lines:35

Number of combinations before packing:35

35 selection(s) built in 0.6 sec.

Number of logic calls:35

-

---

Call no. 1, logic:D:\Data\Webfolders\BUDGET_TOOL\ADMINAPP\BUDGET\FXTrans.LGX

-

---

-

---

Building sub-query 1

-

---

Query Type:0

Max members:

Region:

DIMENSION:CATEGORY

..

..

Ignoring Status

Failed to submit record: ACTUAL,201127C021,SAP,2000,1110101,EUR_Q1,NONINTERCO_NA,PROJECT_NA,2009.FEB, 29.6258647820951

Failed to submit record: ACTUAL,201127C021,SAP,2000,1110101,USD_Q1,NONINTERCO_NA,PROJECT_NA,2009.FEB, 38.5891720531604

....

call 1 completed and data posted in 6.7 sec.

Run completed in 7.3 sec.

****************************************************************************************************

End time --->6:02:46 PM - Date:4/9/2009

****************************************************************************************************

1060 errors writing data

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

Validating members:Subscript out of range

......

[romuald_colletaz]

Hi,

thank you ffor your answer. I'm going to test it.

We are using BPC 5.1 SP3 and we have customed the FXTrans.

Currently I have no accessed to the server but I will test ASAP.

In the case the problem is due to the number of digits, I imagine that we cannot update the strcuture of the fact tables. Is it possible to limit the number of digits directly in the script.

thanks for your help!

Romuald

[i045436]

Hi,

You have to verify on SQL level what column type you have for SignedData in WB table. The numbers generated by logic seems to have too much decimals(13).

You can try to generate manually in a simple SQL insert query into WB tavle using those values to see why the SQL is failing.

Are you using a custom FXTrans.LGX logic or the standard one? What BPC version/SQL version are you using?

Regards,

Mihaela