Stats

  • Locked Locked
  • Replies 8
  • Subscribers 165
  • Views 18850
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Amazing problem while generating BOM

sunscocool

I used MySQL as my local compent database.

Everything goes right until generating BOM.

A Error occurs as :

ERROR(ORCIS-6156): Unknown database field type

I am not sure what's wrong with OrCAD Capture CIS 16.6 has anyone met the same problem? 

Maybe something worng with my Data type set in Mysql database,but I am not sure. 

  • oldmouldy
    Yes, something is likely wrong with your DB field data type, only the ANSI SQL 97 data types are supported, that usually means VARCHAR, Char in Access, for any text fields and FLOAT, Number in Access, for any value fields like pricing. Anything else is unlikely to fly straight.
  • sunscocool

    Thank your for reply

    I have find someway to solve this probelm

    I can copy all the properties from Part  Proerty Editor and then paste it to Excel. Then I can Edit Excel file to get BOM.

    Also there is another efficient way to generate BOM from Tools->Bill of materials , It seems do not care what's wrong with Database Type error.I find it is efficient to generate a BOM file with modifing the export file format like :

    In header

    Item\t;Quantity\t;Reference\t;Part\t;Manufacturer_Part_Number\t;PCB Footprint\t;Price

    In property String

    {Item}\t;{Quantity}\t;{Reference}\t;{Value}\t;{Manufacturer_Part_Number}\t;{PCB Footprint}\t;{Price}

    also you can write the format as what you want,and then import to Excel. 

    All roads to Roma.

    Good luck to who may meet the same problem! 

  • oldmouldy
    The big "BUT" here is that the Tools>Bill of Materials only reads the Schematic properties, it does not use ANY database properties. IF you have something dynamically updated, like Price, or Lead Time, these are unlikely to be maintained the in the schematic properties but there will likely be maintained in an ERP / MRP database. The CIS reports can make use of the database fields, the Capture BOM cannot. (The Tools>Bill of Materials might fit the purpose in some circumstances though)
  • sunscocool

    I tried but it works!

    I tried it just a minute ago in the fllowing steps:

    I changed an Inductor's price in MySQL Database and then I find the inductor in my schematic.

    Right-click the Inductor then select  link database part and then open CIS Explorer

    double-click the selected compent in   CIS Explorer  a update symbal warnning appear , click ok.

    After above steps,I open the inductor's property finding that the price was changed.

    So everything works fine with  Tools>Bill of Materials .

  • oldmouldy
    BECAUSE you have Transfer to Schematic set for the database field(s), open the Schematic in 6 months time, run the BOM and get data from 6 months ago, this doesn't happen if the BOM data comes from the Database directly.
Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.