Skip to Content
0
Former Member
Nov 03, 2016 at 12:08 PM

Error stored procedure after migration from 7.5 MS to 10.1 MS

173 Views

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!