7 Replies Latest reply on Apr 28, 2011 10:46 AM by Patrick.Cashman

    Variant Manager error.


      Hello everyone,


      We recently migrate from DxDesigner 2005 to 2009.2.

      When I tried to replace one part in variant manager keeps displayed error "An ODBC error ocurred: Data type mismatch in criteria expresion"

      The weird thing in here is that I am using the same Data Source Configuration File that I use in DxDatabook, and I don't have any errors when I'm pulling out symbols or others task with DxDatabook.

      I am trying with new projects and also with migrated projects and is not working.

      Do I need to have a whole new and different Data Source Configuration File just for my Variant Manager?




        • 1. Re: Variant Manager error.

          Not knowing your specific .dbc file and product configuration; this is difficult to fix on this site without publicly sharing infomation.


          Please contact product support and create a service request to resolve the issue.



          Gary Lameris

          • 2. Re: Variant Manager error.

            Did you check the VM Match Condition for all your libraries? Perhaps the problem is with one of those.

            • 3. Re: Variant Manager error.

              Make sure that whatever field you are using for "Part Number" is of datatype "text".


              We had ours set to "Number" and got the same error.  I changed it to "text" in all the database tables.  That solved the problem you encountered, and the replace function now works by bringing up a window with a table-like object in it from which I can select a replacement part by double-clicking.  The contents of the table are defined in the Settings dialog > Query results format.  It is in the form:


              $(Part Number)  $(Part Label)  $(whatever other field you want to inlcude in the query results)


              You can change that part around however you want.  You also have to have the VM Match Condition for each table set in the DxDatabook configuration (available from the Settings dialog, the button with the magnifying glass and pencil).  We set ours to match ('=") on the PCB Footprint and Partition fields in our database.  The query searches in your DxDatabook database, not your library


              There is a new error later in the process.  Same error message as before.  It comes when executing the "Create Variant/Function Schematics" button.  The error message is repeated for every database table.  After hitting "OK" for all of them the Variant gets applied to the schematic correctly.  It also flows down through all the other tools - PCB, Fablink, Drawing Editor, without any problem.   I'm not sure why it's there and why everything seems to work in spite of the error . . .  (cue the programmer from Mentor to speak up and explain this)






              • 4. Re: Variant Manager error.

                Thanks for your suggestion, that was exactly the issue we were having with the Variant Manager, we are still doing some functional tests but so far is working.

                • 5. Re: Variant Manager error.

                  I also just took note that the value of "Part Label" is changed when the variant is applied. (in the case of replacing a part)  It adopts the same value as Part Number. To me this is unexpected behavior.  I do not know if it is related to the ODBC error.  I have a message in to our Mentor AE to see if he knows someone at Mentor that knows how the queries are constructed, and if there is any way we can modify them.


                  I suspect the errors are due to the query parameters not matching the database structure.  Not surprising, as it would be very difficult to contemplate every possible database scenario when building a canned query.  I think it would be simple to fix the problem if we could build the queries ourselves, making sure they match our databases.





                  • 6. Re: Variant Manager error.

                    I just logged SR 2399482143 for this issue.

                    • 7. Re: Variant Manager error.

                      Problem solved.


                      From Ed Murphy at Mentor:



                      In DxDB, right-click and choose Configure > Edit  Configuration


                      In the Configuration dialog, click the Update All  button.



                      Click OK and then right-click in DxDataBook and choose  Configure > Save.


                      Close DxDesigner and reopen.


                      I did this, and it worked.  No more errors.



                      Thanks to Ed and anyone else at Mentor who contributed.