Error stored procedure after migration from 7.5 MS to 10.1 MS

[Former Member]

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!

[Former Member]

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

[Former Member]

Hi Arnold,

thank you for answering! I'll try the solution you've suggested.

Regards,

Irina