Hi,
I ran a Data Management Package, which in turns executed the following statements in an LGF.
//=============================================
// Consolidation logic
//=============================================
*RUN_STORED_PROCEDURE = SPRUNCONVERSION( '%APP%', [%CATEGORY_SET%], [%ConsolView_SET%],'GLOBAL','%SCOPETABLE%','%LOGTABLE%')
*RUN_STORED_PROCEDURE = SPRUNCONSO('%APP%', [%CATEGORY_SET%], [%ConsolView_SET%],'%SCOPETABLE%','%LOGTABLE%')
*COMMIT
However I encountered the following error
error querying SQL:Connection failure
I could retrieve and send data without any problem. I also checked that both MSSQLSERVER and
MSSQLServerOLAPService had also started. What else had gone wrong?
I'm attaching the log file below in case it helps troubleshoot.
**************************************************************************************************** Start time --->9:24:52 PM - Date:2/8/2009 (build code:254) **************************************************************************************************** User:SAP-CPMVM\CPMadmin Appset:Demo5b App:LEGAL Logic mode:1 Logic by: Scope by: Data File: Debug File:C:\BPC\Data\Webfolders\Demo5b\LEGAL\PrivatePublications\CPMadmin\TempFiles\\DebugLogic_5_.Log Logic File:C:\BPC\Data\WebFolders\Demo5b\LEGAL\\..\AdminApp\LEGAL\FXCONSOL_Restatement.lgx Selection:C:\BPC\Data\WebFolders\Demo5b\LEGAL\PrivatePublications\CPMadmin\TempFiles\FROM_5_.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:C:\BPC\Data\WebFolders\Demo5b\LEGAL\\..\AdminApp\LEGAL\FXCONSOL_Restatement.lgx ---------------------------------------------------------------------------------------------------- signeddata is YTD ------------------------- Building sub-query 1 ------------------------- Query Type:0 Max members: Executing SPRUNCONVERSION 'LEGAL', [ACTUAL], [C_IMC_LEGAL],'GLOBAL','SPSCOPE_161771','SPLOG_402019' error querying SQL:Connection failure Time to run stored procedure:50.4 sec. call 1 completed and data posted in 51.4 sec. Run completed in 51.9 sec. **************************************************************************************************** End time --->9:25:43 PM - Date:2/8/2009 **************************************************************************************************** error running stored procedure SPRUNCONVERSION 'LEGAL', [ACTUAL], [C_IMC_LEGAL],'GLOBAL','SPSCOPE_161771','SPLOG_402019': Connection failure error running stored procedure SPRUNCONVERSION 'LEGAL', [ACTUAL], [C_IMC_LEGAL],'GLOBAL','SPSCOPE_161771','SPLOG_402019': Connection failure
Thank you!
Sunny