Official | HULFT IoT EdgeStreaming First Step Guide Fourth Edition: July 1, 2021
Log (Database - SQL Server)
This log is output when the following adapters are executed:
-
Database > SQL Server > Insert
-
Database > SQL Server > Insert (result output)
-
Database > SQL Server > Select(1 row)
Check the content and resolve the issue based on the message ID of the execution log that is output.
For details on adapters, refer to Adapter Reference.
Execution log
DSQLSERVER10000
- Log level:
-
DEBUG
- Description:
-
An internal error occurred.
DSQLSERVER10001
- Log level:
-
DEBUG
DSQLSERVER10002
- Log level:
-
DEBUG
- Description:
-
An internal error occurred.
DSQLSERVER10003
- Log level:
-
DEBUG
ESQLSERVER10000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER10001
- Log level:
-
ERROR
ESQLSERVER10002
- Log level:
-
ERROR
ESQLSERVER10003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER10004
- Log level:
-
ERROR
ESQLSERVER10005
- Log level:
-
ERROR
ESQLSERVER10006
- Log level:
-
ERROR
ESQLSERVER10007
- Log level:
-
ERROR
ESQLSERVER10008
- Log level:
-
ERROR
ESQLSERVER10009
- Log level:
-
ERROR
ESQLSERVER10010
- Log level:
-
ERROR
ESQLSERVER10011
- Log level:
-
ERROR
ESQLSERVER11000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER11001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER11002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER11003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER11004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER11005
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
WSQLSERVER12000
- Log level:
-
WARNING
ESQLSERVER12000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER13000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER13001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER13002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER13003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER13004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER14000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER14001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER14002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER14003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER14004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER15000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER15001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER15002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER16000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER16001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER16002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
WSQLSERVER17000
- Log level:
-
WARNING
ESQLSERVER17000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER17001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER18000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER18001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER18002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER18003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER18004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER19005
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER20000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER20001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER20002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER20003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER20004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
DSQLSERVER21000
- Log level:
-
DEBUG
DSQLSERVER22000
- Log level:
-
DEBUG
DSQLSERVER00000
- Log level:
-
DEBUG
DSQLSERVER00001
- Log level:
-
DEBUG
DSQLSERVER00002
- Log level:
-
DEBUG
DSQLSERVER00003
- Log level:
-
DEBUG
ESQLSERVER00000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00004
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00005
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00006
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00007
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00008
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00009
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00010
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER00011
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00012
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00013
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00014
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00015
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00016
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00017
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00018
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00019
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00020
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00021
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER00022
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01002
- Log level:
-
ERROR
ESQLSERVER01003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01005
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER01006
- Log level:
-
ERROR
- Description:
-
Failed to connect to the database.
- Measure:
-
Check the SQL Server connection settings information specified for the connection destination. Also, check the network environment to connect to the destination database.
ESQLSERVER01007
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
DSQLSERVER02000
- Log level:
-
DEBUG
WSQLSERVER02000
- Log level:
-
WARNING
WSQLSERVER02001
- Log level:
-
WARNING
WSQLSERVER02002
- Log level:
-
WARNING
WSQLSERVER02003
- Log level:
-
WARNING
ESQLSERVER02000
- Log level:
-
ERROR
ESQLSERVER02001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02003
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER02004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02005
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER02006
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02007
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02008
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02009
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02010
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02011
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02012
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02013
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02014
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02015
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02016
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER02017
- Log level:
-
ERROR
- Description:
-
The data type of the column specified with SELECT is not supported.
- Measure:
-
Remove the column from the execution conditions for the processing.
ESQLSERVER02018
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
DSQLSERVER03000
- Log level:
-
DEBUG
DSQLSERVER03001
- Log level:
-
DEBUG
DSQLSERVER03002
- Log level:
-
DEBUG
DSQLSERVER03003
- Log level:
-
DEBUG
ESQLSERVER03000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03004
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER03005
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER03006
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER03007
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ESQLSERVER03008
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03009
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03010
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03011
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03012
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03013
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03014
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03015
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03016
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03017
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03018
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03019
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03020
- Log level:
-
ERROR
- Description 1:
-
The operation permissions for the target table of the insertion processing are not granted.
- Description 2:
-
The data type of the input value is different from the data type that is set for the target table of the insertion processing.
- Measure 1:
-
Check the operation permissions for the target table of the insertion processing.
- Measure 2:
-
For the data type of the input value, specify the data type that is set for the target table of the insertion processing.
ESQLSERVER03021
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER03022
- Log level:
-
ERROR
- Description:
-
An error occurred in the database.
- Measure:
-
Check the content of the message and then check the SQL Server connection settings information specified for the connection destination and the state of the database. Also, check the network environment to connect to the destination database.
ISQLSERVER99000
- Log level:
-
INFO
ISQLSERVER99001
- Log level:
-
INFO
ISQLSERVER99002
- Log level:
-
INFO
ESQLSERVER99000
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99001
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99002
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99003
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99004
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99005
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99006
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99007
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99008
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99009
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99010
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99011
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99012
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99013
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99014
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99015
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99016
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99017
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99018
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99019
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99020
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99021
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99022
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99023
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99024
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99025
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99026
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99027
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99028
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
ESQLSERVER99029
- Log level:
-
ERROR
- Description:
-
An internal error occurred.
FSQLSERVER99000
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99001
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99002
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99003
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99004
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99005
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99006
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
FSQLSERVER99007
- Log level:
-
FATAL
- Description:
-
An internal error occurred.
Official | HULFT IoT EdgeStreaming First Step Guide Fourth Edition: July 1, 2021