Skip to Content
author's profile photo Former Member
Former Member

spcopyopening not working anymore

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2012 at 11:37 AM

    Arnold,

    Are you able to run any other SP, if yes then you are good from system and server side. You may also like to check the logic file...please check if the sub-query 1 in your lgf or lgf is misplaced from what was in past. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      thanks, turns out it was this bit of code

      //--------------------------------------------------------------------------------------------------------------------------------

      // Recording the total number of blocking errors on VALFLAG (Work Status account)

      //--------------------------------------------------------------------------------------------------------------------------------

      *SELECT ("%DATASRC_LIST%","[ID]","DATASRC","DATASRC_TYPE='I'")

      *XDIM_MEMBERSET DATASRC=%DATASRC_LIST%

      *XDIM_MEMBERSET CONSOSCOPE=G_NONE

      *XDIM_MEMBERSET CURRENCY=LC

      *XDIM_MEMBERSET INTCO=I_NONE

      *WHEN SIGNEDDATA

      *IS <>0

      *WHEN ACCOUNT.DIMLIST_VR

      *IS VR_VALREL

      *REC(ACCOUNT=VALFLAG,ACCTDETAIL=F_BAL,EXPRESSION=1)

      *ELSE

      *REC(ACCOUNT=VALFLAG,ACCTDETAIL=F_BAL,EXPRESSION=0)

      *ENDWHEN

      *ENDWHEN

      *COMMIT

      which I copied from the SAP IFRS starter kit.

  • Posted on Aug 29, 2012 at 10:23 AM

    Hi Arnold,

    after

    DIMENSION:CATEGORY

    BUDGET

    DIMENSION:ENTITY

    1104

    DIMENSION:TIME

    2012.JAN

    is the Executing SPCOPYOPENING? (because I see ...)

    There aren't messages related to the stored proc.?

    Check if the COM+ services are ok, if the DB server is responding, try to execute other stor.proc., if they doesn't work try to modify application (eventually proess the cube on the db server) or process all dims or if possible to restart the server.

    Kind regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Roberto Vidotti

      Hi Roberto,

      we are working with a single server environment, so it is only the one server. COM+ seem to be okay, I can't see any blocked ones.

      I do have frequent time out errors for MSSQLOLAPService but I not at the same time as problems with running the scripts in BPC.

      I have compared the lgf and lgx files and they are what I would expect.

      Thanks,

      Arnold

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.