Question Status

Suggested Answer
Patrick F. asked a question on 16 Jan 2012 7:00 AM

Hello,

we have here a problem with the Excel AddIn and a large table. My clleague tries to import ZipCodes into the table LogisticsAddressZipCode which contains currently 581071 records. I can add it without problems via "Add Data"->"Add tables". But when I click on "Refresh all" it works quite a while with the message "Reading data for ZIP/postal codes". Then at first a popup with the message "An exception has been thrown when reading the stream" and then "The socket connection has been disposed". As the Excel addin works with every other table we tried and it takes so long I assume that the reason for these errors is the size of the table. Am I right with my assumption? If no: does anybody know what the real cause could be? And has anybody a tipp how I can solve this problem?

Regards
Patrick

Reply
Suggested Answer
Bill 'Luther' Thompson responded on 16 Jan 2012 9:32 AM

Have you modified this table?  The reason I am asking is that when I attempt to duplicate this issue, I go into Excel, choose Dynamics AX tab, Add Data >> Tables, and choose LogisticsAddressZipCode as the table, insert it and click OK, I get errors on the table having surrogate foreign key expansion errors.  The errors are on the District key field not having a replacement key and the CitRecId not having a replacement key.

I am running on a post CU2 kernel build with some Office Add-in fixes, so this may be why I am getting the error message and you are not.  

Based on the error I am seeing, the add-in won't work on this table.

Best Regards,

Bill Thompson

Dynamics AX/Sure Step Online Support Engineer - Online Support Engineer

============================================================

When responding to posts, please 'Reply to Group' via your newsreader so that

others may learn and benefit from your issue.

============================================================

This posting is provided 'AS IS' with no warranties, and confers no rights.

============================================================

Reply
Suggested Answer
Bill 'Luther' Thompson responded on 16 Jan 2012 9:32 AM

Have you modified this table?  The reason I am asking is that when I attempt to duplicate this issue, I go into Excel, choose Dynamics AX tab, Add Data >> Tables, and choose LogisticsAddressZipCode as the table, insert it and click OK, I get errors on the table having surrogate foreign key expansion errors.  The errors are on the District key field not having a replacement key and the CitRecId not having a replacement key.

I am running on a post CU2 kernel build with some Office Add-in fixes, so this may be why I am getting the error message and you are not.  

Based on the error I am seeing, the add-in won't work on this table.

Best Regards,

Bill Thompson

Dynamics AX/Sure Step Online Support Engineer - Online Support Engineer

============================================================

When responding to posts, please 'Reply to Group' via your newsreader so that

others may learn and benefit from your issue.

============================================================

This posting is provided 'AS IS' with no warranties, and confers no rights.

============================================================

Reply
Patrick F. responded on 18 Jan 2012 1:38 AM

I have modified the table in order to be able to open the table in Excel, without the modifications I couldn't open the table in Excel also.

We have kernel version 6.0.947.280 installed.

Reply