Management Reporter Error : General Ledger Transaction to Fact (Errors Encountered)

(0) Share

Report

Posted on by Community Member

After installing Management Reporter for ERP the processing fails. The error throws a AX 2012 General Ledger Transactions to Fact -- One or more errors occurred. -- Invalid operation. The connection is closed.

The full error exception in the logs is the following:

----- Log Start -----

task AX 2012 General Ledger Transactions to Fact progress at 2.78389820331594% ...
ERROR TID:TP-5 [2017-08-25T09:07:02.8077106-06:00]: An exception was thrown while reading object from table, GJAE, with key, 5672651075.
   --- Exception Dump ---
   Caught Exception: [System.Data.SqlClient.SqlException] A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
   Stack trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead)
   at System.Data.SqlClient.TdsParserStateObject.TryReadUInt16(UInt16& value)
   at System.Data.SqlClient.TdsParser.TryGetTokenLength(Byte token, TdsParserStateObject stateObj, Int32& tokenLength)
   at System.Data.SqlClient.TdsParser.TryGetDataLength(SqlMetaDataPriv colmeta, TdsParserStateObject stateObj, UInt64& length)
   at System.Data.SqlClient.TdsParser.TryProcessColumnHeaderNoNBC(SqlMetaDataPriv col, TdsParserStateObject stateObj, Boolean& isNull, UInt64& length)
   at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
   at System.Data.SqlClient.SqlDataReader.TryReadColumnHeader(Int32 i)
   at System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i)
   at System.Data.SqlClient.SqlDataReader.IsDBNull(Int32 i)
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.AX2012Helpers.ReadLong(SqlDataReader reader, String columnName)
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.ActualTransactionObjectProvider.<ReadObjectsSql>d__f.MoveNext()

   Inner Exception: [System.ComponentModel.Win32Exception] An existing connection was forcibly closed by the remote host
   Stack trace:

task AX 2012 General Ledger Transactions to Fact log event : Error ...
ERROR TID:TP-4 [2017-08-25T09:07:08.0409481-06:00]: One or more errors occurred.
   --- Exception Dump ---
   Caught Exception: [System.AggregateException] One or more errors occurred.
   Stack trace:
   at System.Threading.Tasks.Task.WaitAll(Task[] tasks, Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.GeneralLedgerTransactionObjectProvider.<ReadObjects>d__33.MoveNext()
   at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)

   Inner Exception: [System.InvalidOperationException] Invalid operation. The connection is closed.
   Stack trace:
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead)
   at System.Data.SqlClient.TdsParserStateObject.TryReadUInt16(UInt16& value)
   at System.Data.SqlClient.TdsParser.TryGetTokenLength(Byte token, TdsParserStateObject stateObj, Int32& tokenLength)
   at System.Data.SqlClient.TdsParser.TrySkipValue(SqlMetaDataPriv md, Int32 columnOrdinal, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TrySkipRow(_SqlMetaDataSet columns, Int32 startCol, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.TryCleanPartialRead()
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.ActualTransactionObjectProvider.<ReadObjectsSql>d__f.MoveNext()
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.ActualTransactionObjectProvider.<ReadObjects>d__0.MoveNext()
   at Microsoft.Dynamics.Integration.Adapters.AX2012GL.GeneralLedgerTransactionObjectProvider.<>c__DisplayClass31.<ReadObjects>b__23()
   at System.Threading.Tasks.Task.Execute()

task AX 2012 General Ledger Transactions to Fact log event : Error ...
08/25/2017 15:07:08: task 88065639-18d3-4aa3-9661-a25c02fb6299 is Faulted

----- Log End -----

Anyone?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

It means that management reporter can't make a connection to sql server. Usually, this is caused by two connections being open and conflicting with themselves (in simple terms), sometimes it's a firewall issue, and sometimes it is a bad network connection. There is a real simple test to do first which works about half the time. First stop the management reporter service. Then, restart the sql service. Then restart the management reporter service. If that doesn't work, do your connection type of troubleshooting -- firewall ports open, can you ping, netsh, trace the connection.. or uninstall/reinstall management reporter. Or stop and restart CDC through sql.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response, already check the connections to the sql server and it's working properly. After some additional troubleshooting it appears only the FACT, FACTRESOLVING, FactTypeQualifierStaging and FiscalYearStaging tables are not populating. Any clues? Thanks

Was this reply helpful? Yes No
Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

which version of management reporter are you using? This actually happened in one of the earlier versions before a patch came out. And are you absolutely sure that there aren't two different CDC processes trying to populate the connection pool. Did you stop CDC and restart it to ensure this wasn't the cause?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Version 2.1.12000.26, Did restart the CDC and made a SQL connections check. No other CDC process is accessing the Database at this point.

Any other clue? Thanks

Was this reply helpful? Yes No
Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Can you run this query:

Select * from sys.dm_cdc_errors

And then let us know what you see. I want to see if you get a little more information on why it is failing. Ordinarily, it would actually be the connection that is complaining about, but it could be the security also or a bad sql query. The CDC error logs are very good about capturing this sort of information when it occurs.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ran the query on both Sql Servers (AX Instance & Management Reporter) and no results. Checking the tables only the FACT, FACTRESOLVING, FactTypeQualifierStaging and FiscalYearStaging tables doesn't show data. Any ideas on why this can happen?

Thanks

Was this reply helpful? Yes No
Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

For the GeneralJournalAccountEntry table, what number record has the recid 5672651075? Is it the first record, 10th record in the table etc.. and is there anything special about that record from the other?

Was this reply helpful? Yes No
André Arnaud de Cal... 304,040 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Steve,

You could read my blog with some tips for troubleshooting. I hope it will help you.

https://kaya-consulting.com/troubleshooting-management-reporter-integration-with-ax-2012/

@Brandon: What is the purpose of RecordID "5672651075"?

Was this reply helpful? Yes No
Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Arnauld, I like your blog post on this one. Initially, I figured it would be something obvious with CDC or the connection not synchronizing because it was giving a connection fault. But after he checked everything, I wasn't so sure. In those sorts of cases, as your blog post correctly points out, it's usually a data integrity problem. From an investigation standpoint, I'd start with the RECId of the table that it is complaining about if all the usual causes are eliminated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Andre and Brandon, as you suggested we are going to review the Recid of the table to see if there is something wrong. I will send another update once this is completed.

Was this reply helpful? Yes No