Skip to content
+1-888-319-3663

COMMUNITY FORUM

Executing from TRANSACT getting logs returned

Dean Edouarde asked 5 years ago
I’m executing the following from a SPROC…
 DECLARE @sqlCmd VARCHAR(1000) = ‘\\10.10.0.6\SmartConnect2\eOne.SmartConnect.RunMapConsole.exe CHR810’
   EXEC xp_CmdShell @sqlCmd
where the SmartConnect2 is a shared folder with everyone full control (for testing purposes)
There is only 1 record in the source deck.
The MAP runs correctly with no error when executing from within SC
The EXEC above returns no command errors (e.g. No ‘Not Found’) and loads and executes RunMapConsole.exe
It returns about 5300 lines of logs directly back into Transact similar to the ones below…
NULL
C:\Windows\system32>L:
NULL
L:\>cd\
NULL
L:\>cd “program files <86>”
NULL
L:\Program Files (x86)>cd “eone solutions”
NULL
L:\Program Files (x86)\eOne Solutions>cd smartConnect
NULL
L:\Program Files (x86)\eOne Solutions\SmartConnect>eOne.SmartConnect.RunMapConsole.exe CHR810
NULL
    if exists (select 1 from sys.objects where object_id = OBJECT_ID(N'[FK37B861483BE1AC37]’) AND parent_object_id = OBJECT_ID(‘[MsCrm2011ActivityPartyField]’))
alter table [MsCrm2011ActivityPartyField]  drop constraint FK37B861483BE1AC37
NULL
NULL
    if exists (select 1 from sys.objects where object_id = OBJECT_ID(N'[FK915365F2C0A3AAB9]’) AND parent_object_id = OBJECT_ID(‘[MsCrm2011LookupField]’))
alter table [MsCrm2011LookupField]  drop constraint FK915365F2C0A3AAB9
    alter table [MsGpRealTimeRunCompany]
        add constraint FKBF77A2D97C97C8AE
        foreign key (MsGpRealTimeDataSourceAssociationId)
        references [MsGpRealTimeDataSourceAssociation]
NULL
    alter table [KeyColumn]
        add constraint FK522BED99BD3C2A93
        foreign key (MapId)
        references [Map]
The only extension loaded in SC is the GP Add-In
Answers

If you would like to submit an answer or comment, please sign in to the eOne portal.