1

Topic: Unhandled error opening Names/Addresses

Hello

Our copy of R6 (v.6.26.2.286 with Dict 03X Windows 10 PC) produces unhandled errors when opening Names & Addresses hierarchy or attempting to search the Location hierarchy.

Both give exception error "could not convert variant of type (Null) into type (String)"

Any help gratefully received

Simon

Post's attachments

Error-73676056252217.txt 27.15 kb, 1 downloads since 2018-03-07 

You don't have the permssions to download the attachments of this post.

2

Re: Unhandled error opening Names/Addresses

You have some locations and names without any custodian. Not sure when or how this would have happened, but I have seen it in other databases. Batch Update to fix is attached, or if you have access to SQL then the simple update queries are in the xml file.  This update is in System Supplied/Problem Correct/Data Correction Custodian.

Post's attachments

JNCCDATACorrection2.xml 658 b, 2 downloads since 2018-03-07 

You don't have the permssions to download the attachments of this post.
Mike Weideli

3

Re: Unhandled error opening Names/Addresses

Thanks Mike, can't see anything attached to this post

4

Re: Unhandled error opening Names/Addresses

A bit hasty posting the reply. Batch update now attached to original post.

Mike Weideli

5

Re: Unhandled error opening Names/Addresses

Sorry! thank you Mike!