TM Master Common Errors
- 5.2.0 SendAsDeniedException error when using smtp.office365.com for emails
- A connection was successfully established with the server, but then an error occurred during the login process
- Attaching files to component - Error: Object reference not set to an instance of an object.
- Data at the root level is invalid. Line 1, position 1
- Error when opening Inventory -> Spare parts
- Language Compatibility Issues Turkish, Portuguese & Spanish
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- Object reference not set to an instance of an object - SetSparePartImage
- OutOfMemory
- Printer does not support A4 papersize
- Rebuilding / Reorganisation of Indexes
- Report Header Name is Shorter Than 3 Characters
- System.ArgumentException: Parameter is not valid.
- System.Exception: RelatedDataView is Disposed
- System.Runtime.InteropServices.COMException
- System.Runtime.InteropServices.COMException. The remote procedure call failed
- System.Xml.XmlException: Invalid character in the given encoding. Line 1, position 1.
- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- The conversion of the varchar data type into datetime produced an out of range value
- The process cannot access the file because it is being used by another process.
- The specified string is not in the form required for an e-mail address
- The timeout period elapsed prior to completion of the operation or the server is not responding
- Transport level error - The semaphore timeout period has expired
- Transport level error - The specified network name is no longer available
- Unable to add SRF report (System.Runtime.InteropServices.COMException. The remote procedure call failed.)
- Visual Styles-related operation resulted in an error because visual styles are currently disabled in the client area
- You do not have permission to perform this action
Language Compatibility Issues Turkish, Portuguese & Spanish
Solution
The best way to come around this will be to install the server operating system to English UK/US or change it to the English UK/US and do a restart of the server.
Different solutions:
Portuguese
SQL Server User with default language Portuguese does not support ISO 8601 Date Formats for SQL
(They have a valid YYYY-DD-MM format that can fail on the 13th - 31st of any month, and is wrong on the 1st-12th)
Spanish
SQL Server User with default language Spanish does not support ISO 8601 Date Formats for SQL
(They have a valid YYYY-DD-MM format that can fail on the 13th - 31st of any month, and is wrong on the 1st-12th)
Turkish
Windows User with Turkish Regional Settings fail at parsing SQL Server Connection Strings
https://garygregory.wordpress.com/2015/11/03/java-lowercase-conversion-turkey/
https://gist.github.com/anova/6902147
The issue encountered was that "I".ToLower() != "i" in Turkish
Common errors:
1.
2.
Infotech.Data.DataComponents.DataCompException: Invalid column name 'tmcomponentjobid'.
Invalid column name 'componentjobid'.
Invalid column name 'tmjobid'.
Invalid column name 'jobid'.
Invalid column name 'tmcomponentjobintervalID'.
Invalid column name 'tmcomponentjobintervalID'.
Invalid column name 'componentid'.
Invalid column name 'tmcomponentid'.
Invalid column name 'tmjobhistoryid'.
The multi-part identifier "tmcomponentjobinterval.intervaltype" could not be bound.
The multi-part identifier "tmcomponentjobinterval.intervaltype" could not be bound. ---> System.Data.SqlClient.SqlException: Invalid column name 'tmcomponentjobid'.
3.
Infotech.Data.DataComponents.DataCompException: Invalid column name 'isGreen'.
Invalid column name 'isGreen'. ---> System.Data.SqlClient.SqlException: Invalid column name 'isGreen'.
Invalid column name 'isGreen'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article