Skip to Content
0
Former Member
Feb 08, 2009 at 01:57 PM

error querying SQL:Connection failure

19 Views

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