Skip to Content
0

Error stored procedure after migration from 7.5 MS to 10.1 MS

Nov 03, 2016 at 12:08 PM

102

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arnold Warhonowicz Nov 15, 2016 at 03:47 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Arnold,

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

Regards,

Irina

0