Using eOne.SmartConnect.RunMapConsole.exe to run maps as a batch command creates all kinds of SQL feedback
David asked 6 years ago
Hello,
What is all the SQL feedback created when running eOne.SmartConnect.RunMapConsole.exe at the command line for batch files?
Is it anything to be concerned about?
Any way to turn it off?
See sample below copies from Windows command window….
Thanks,
David B
references [RealTimeDataSourceAssociationBase]
alter table [MsGpRealTimeDataSourceAssociation]
add constraint FK6641C5BE50B665F
foreign key (MsGpRealTimeDataSourceAssociationId)
references [RealTimeDataSourceAssociationBase]
alter table [SalesForceRealTimeDataSourceAssociation]
add constraint FK5D6AD49F9BD9D1AC
foreign key (SalesForceRealTimeDataSourceAssociationId)
references [RealTimeDataSourceAssociationBase]
alter table [RealTimeDataSourceBase]
add constraint FKA7322CB0D93B5A84
foreign key (RealTimeDataSourceBaseId)
references [DataSourceBase]
alter table [MsCrm2011RealTimeDataSource]
add constraint FKD9BEE6FBB4D63091
foreign key (MsCrm2011RealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MssqlRealTimeDataSource]
add constraint FK9594376B3E59EBA4
foreign key (MssqlRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MsCrmRealTimeDataSource]
add constraint FK4CF0B7F266B38567
foreign key (MsCrmRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MsGpRealTimeDataSource]
add constraint FK7A94F1A5A16899BA
foreign key (MsGpRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [ExtenderRealTimeDataSource]
add constraint FK6A139E1AF97D2C1A
foreign key (ExtenderRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [SalesForceRealTimeDataSource]
add constraint FK85F7927D5A4AE847
foreign key (SalesForceRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [TranslationTableLine]
add constraint FKB2F25FD8103FD2CB
foreign key (TranslationTableId)
references [TranslationTable]
alter table [MsGpRealTimeRegisterCompany]
add constraint FKB39E555A3026EAB8
foreign key (MsGpRealTimeDataSourceId)
references [MsGpRealTimeDataSource]
alter table [MsGpRealTimeRunCompany]
add constraint FKBF77A2D97C97C8AE
foreign key (MsGpRealTimeDataSourceAssociationId)
references [MsGpRealTimeDataSourceAssociation]
alter table [KeyColumn]
add constraint FK522BED99BD3C2A93
foreign key (MapId)
references [Map]
What is all the SQL feedback created when running eOne.SmartConnect.RunMapConsole.exe at the command line for batch files?
Is it anything to be concerned about?
Any way to turn it off?
See sample below copies from Windows command window….
Thanks,
David B
references [RealTimeDataSourceAssociationBase]
alter table [MsGpRealTimeDataSourceAssociation]
add constraint FK6641C5BE50B665F
foreign key (MsGpRealTimeDataSourceAssociationId)
references [RealTimeDataSourceAssociationBase]
alter table [SalesForceRealTimeDataSourceAssociation]
add constraint FK5D6AD49F9BD9D1AC
foreign key (SalesForceRealTimeDataSourceAssociationId)
references [RealTimeDataSourceAssociationBase]
alter table [RealTimeDataSourceBase]
add constraint FKA7322CB0D93B5A84
foreign key (RealTimeDataSourceBaseId)
references [DataSourceBase]
alter table [MsCrm2011RealTimeDataSource]
add constraint FKD9BEE6FBB4D63091
foreign key (MsCrm2011RealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MssqlRealTimeDataSource]
add constraint FK9594376B3E59EBA4
foreign key (MssqlRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MsCrmRealTimeDataSource]
add constraint FK4CF0B7F266B38567
foreign key (MsCrmRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [MsGpRealTimeDataSource]
add constraint FK7A94F1A5A16899BA
foreign key (MsGpRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [ExtenderRealTimeDataSource]
add constraint FK6A139E1AF97D2C1A
foreign key (ExtenderRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [SalesForceRealTimeDataSource]
add constraint FK85F7927D5A4AE847
foreign key (SalesForceRealTimeDataSourceId)
references [RealTimeDataSourceBase]
alter table [TranslationTableLine]
add constraint FKB2F25FD8103FD2CB
foreign key (TranslationTableId)
references [TranslationTable]
alter table [MsGpRealTimeRegisterCompany]
add constraint FKB39E555A3026EAB8
foreign key (MsGpRealTimeDataSourceId)
references [MsGpRealTimeDataSource]
alter table [MsGpRealTimeRunCompany]
add constraint FKBF77A2D97C97C8AE
foreign key (MsGpRealTimeDataSourceAssociationId)
references [MsGpRealTimeDataSourceAssociation]
alter table [KeyColumn]
add constraint FK522BED99BD3C2A93
foreign key (MapId)
references [Map]
Answers
Patrick Roth Staff answered 6 years ago
That is all stuff for the version upgrade that I think runs when you log into SC. So looks like the runmapconsole exe is running the same process (which makes some sense).
No, it isn’t going to hurt anything – I see that in mine plus a whole bunch of spaces that get kicked out as well for whatever it is doing.
As I note, they don’t hurt anything – but you could add redirect to your bat file.
at the end put of the lineput
> myfile.txt
to shoot the output to a text file
or better yet
> NUL
which redirects to DEV NULL which means “nowhere”
No, it isn’t going to hurt anything – I see that in mine plus a whole bunch of spaces that get kicked out as well for whatever it is doing.
As I note, they don’t hurt anything – but you could add redirect to your bat file.
at the end put of the lineput
> myfile.txt
to shoot the output to a text file
or better yet
> NUL
which redirects to DEV NULL which means “nowhere”
David B replied 6 years ago Thanks for the response Patrick. I’m not sure I understand what you mean by version upgrade since it does this output every time I run a map at the command line instead of it being a one time and done scenario. Can you further explain? By the way, it changes the color of the output font to black so this stuff is invisible when running the map.
Patrick Roth Staff replied 6 years ago And it happens every time you log into smartconnect – that’s why it takes so long.
When you log into SC, it runs through data checks on all the tables and would upgrade anything that it needs to (if it can). That’s one reason it takes so long to log into the UI.
And apparently the same thing happens using the RunMapConsole.exe.