Skip to Content
0
Former Member
Aug 29, 2012 at 10:03 AM

spcopyopening not working anymore

30 Views

Hi,

This morning I ran a copy opening balances and it worked fine. A bit later I tried to run it again and though the package status was again success, no data was copied into the new period (a different period from the inital run).

I did not change the script nor the package, so I would not have expected a problem.

I then checked the log and found a difference. This is from the first, successfull run:

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

Start time --->9:21:38 AM - Date:8/29/2012 (build code:7.5.109)

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

User:INTRA\arwarh

Appset:LIVE

App:CONSOLIDATION

Logic mode:1

Logic by:

Scope by:

Data File:

Debug File:D:\BPC\Data\Webfolders\LIVE\CONSOLIDATION\PrivatePublications\arwarh\TempFiles\DebugLogic_643_01293551611.Log

Logic File:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\\..\AdminApp\CONSOLIDATION\Copy_Opening.LGX

Selection:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\PrivatePublications\arwarh\TempFiles\FROM_643_.TMP

Run mode:1

Query size:0

Delim:,

Query type:0

Simulation:0

Calc diff.:1

Formula script:

Max Members:

Test mode:0

Is Modelling:1

Number of logic calls:1

----------------------------------------------------------------------------------------------------

Call no. 1, logic:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\\..\AdminApp\CONSOLIDATION\Copy_Opening.LGX

----------------------------------------------------------------------------------------------------

signeddata is YTD

-------------------------

Building sub-query 1

-------------------------

Query Type:0

Max members:

Executing SPCOPYOPENING [CONSOLIDATION],[BUDGET],[<NULL>],[SPSCOPE_2904],[SPLOG_2903]

...

This is from the second run, that did not copy an data:

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

Start time --->10:44:46 AM - Date:8/29/2012 (build code:7.5.109)

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

User:INTRA\arwarh

Appset:LIVE

App:CONSOLIDATION

Logic mode:1

Logic by:

Scope by:

Data File:

Debug File:D:\BPC\Data\Webfolders\LIVE\CONSOLIDATION\PrivatePublications\arwarh\TempFiles\DebugLogic_645_462877229.Log

Logic File:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\\..\AdminApp\CONSOLIDATION\Copy_Opening.LGX

Selection:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\PrivatePublications\arwarh\TempFiles\FROM_645_.TMP

Run mode:1

Query size:0

Delim:,

Query type:0

Simulation:0

Calc diff.:1

Formula script:

Max Members:

Test mode:0

Is Modelling:1

Number of logic calls:1

----------------------------------------------------------------------------------------------------

Call no. 1, logic:D:\BPC\Data\WebFolders\LIVE\CONSOLIDATION\\..\AdminApp\CONSOLIDATION\Copy_Opening.LGX

----------------------------------------------------------------------------------------------------

signeddata is YTD

-------------------------

Building sub-query 1

-------------------------

Query Type:0

Max members:

Region:

DIMENSION:CATEGORY

BUDGET

DIMENSION:ENTITY

1104

DIMENSION:TIME

2012.JAN

...

For some reason, the first time round, the sub query seems to execute the stored procedure, the second time not.

Does anyone have an idea why this would happen? Again, the only thing I did between the two runs was to write a couple of EVDRE reports.

Thanks,
Arnold