Skip to Content
avatar image
Former Member

Error stored procedure after migration from 7.5 MS to 10.1 MS

Hi everyone,

After the environment migration when lauching the Opening Stored Procedure the following error occures:

DetailMsg : {Error running stored procedure SPCOPYOPENING [LEGAL], [STATUTORY], [LC],[SPSCOPE_720],[SPLOG_719]: Incorrect syntax near the keyword 'as'.
Invalid object name '#T_DETENTITY'.
Invalid object name '#T_DETENTITY'.
Invalid object name '#T_DETENTITY'.
Invalid object name '#T_DETENTITY'.
Invalid object name '#T_DETENTITY'.
Invalid object name '#T_DETENTITY'.
DIMENSION : AccDetail
DIMENSION : AccountL
DIMENSION : Category
DIMENSION : ConsolView
DIMENSION : DataSrcL
DIMENSION : Entity
DIMENSION : IntCo
DIMENSION : Time
INSERT INTO #T_DETENTITY SELECT a.ENTITY, a.CURRENCY AS CURRENCYPARENT, b.TIMEID, b.OPETIMEID AS OPENING_TIMEID as TIMEID FROM #T_MBRENTITY a, #T_TIME b }

More precisely, in order to migrate in the right way the environment the following steps were made:

- Restore environment 7.5

- Technical migration using the BPC tool

- Dimensions processing (properties time dimension update: TIMEID and BASE_PERIOD)

- Modify models in order to rebuild the structure and index

The similar occurs when the Consolidation is launched.

The Opening procedure in the Environment Shell works.

The dimension' properties from our environment are the same as the Environment Shell one.

Every suggestions are welcome.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 15, 2016 at 03:47 PM

    Hi,

    are you launching the SP from datamanger in Excel? If yes, please try to delete the package and then restate it by using the dts(x) file from the EnvironmentShell.

    BR,
    Arnold

    Add comment
    10|10000 characters needed characters exceeded