Very useful error message from Pervasive DI



  • Error writing to file or table in  Form_Activate(rnstatus.frm) (25508)

    NOTE: Be sure to check the log file for additional information.

    NOTE: Be sure to check the log file for additional information.

    Except there is no log file. 😦



  • @Nagesh said:

    Error writing to file or table in  Form_Activate(rnstatus.frm) (25508)

    The data you are trying to upload might be corrupt..Check for data validations, duplicate key values, special characters etc in data. Try to upload the same via data loader to a test area and check on error file to identify where the error exist.

    Check page 59 from the following link to set the log files to include the errors and go the directory of log file see the content to know about the error.


    Filed under: All my own work.



  • I am doing that search already, but the issue is I am having primary key of integer value in my source data. Now in my target I put that as Action key, but it still throwing same error.



  • @Nagesh said:

    Except there is no log file.

    Yes there is. Look in the log file to find out where it's kept.



  • Found logfile and it is also filled with some gibberish and most useful message in that heap is

    07/07/2014 13:35:33   1      0 O Global                                                           Going for Upsert. 07/07/2014 13:35:33   1      0 O Global                                                           Establishing new salesforce.com session due to potential session timeout 07/07/2014 13:35:35   4      8 E Salesforce                                                       Insert error code DUPLICATE_VALUE: duplicate value found:

    i am having list of active asset and active_asset_hdr_id__c is my key. so it should the UPSERT like I am telling it too, but it keep screaming for unknown duplicate value

    The primery key is in the database



  • Ok. This is not a pervasive WTF, but a salesforce WTF. Sales force want me to mark the key as Unique on Salesforce.com also. @Nagesh did not do that, and DI did not give him that warning, but after going through 1000 forum posts on "IT WORKS ON MY MACHINE", it has come to me through drinking loads of coffee and divine prayer that the answer was in SFDC.

    So boys and men (no girls on internet), to solve this, just set the Unique id and external system on custom object in Salesforce and @codinghorror is your uncle



  • @Nagesh said:

    but a salesforce WTF

    Doesn't surprise me. The best solution to any SFDC problem is to burn it.



  • @chubertdev said:

    Doesn't surprise me. The best solution to any SFDC problem is to burn it.

    in real life any complex business problem can be solved with SFDC. in real life any complex business problem can be solved with SFDC and JAVA. in real life any complex business problem can be solved with SFDC, JAVA and @commonsense.

    http://imgur.com/gm6FCqg



  • Most upserts (insert or replace) require the unique key to be present to determine a 'replace' is actually needed. Without that unique key flagged it doesn't know which fields matter to force a replace.

    What's interesting, is it flags the duplicate key, but doesn't trigger the replace.

    Are you going through two database tools? (I don't know anything about the systems listed)



  • @Matches said:

    Most upserts (insert or replace) require the unique key to be present to determine a 'replace' is actually needed. Without that unique key flagged it doesn't know which fields matter to force a replace.

    What's interesting, is it flags the duplicate key, but doesn't trigger the replace.

    Are you going through two database tools? (I don't know anything about the systems listed)

    There are two connections: 1 - sql server 2008 R2 database. 2 - Oracle database 10G.
    I am getting data from these two by using linked server mode in sql server and merging them.

    then using result of the query, I am upserting ™ the info to SFDC. What @Nagesh found is that SFDC need unique key to be setup as unique + external Id checkbox to be checked. then the whole thing works well.

    thanks for the information so @Nagesh can be more carefull next tiMe.



  • Just watch out for @the_dragon, I heard he's hungry.


  • Discourse touched me in a no-no place

    @Nagesh said:

    http://imgur.com/gm6FCqg

    I see that Buddha never had to deal with SalesForce…



  • Am I the only one here with an app on AppExchange?



  • @chubertdev said:

    Am I the only one here with an app on AppExchange?

    What kind of app is it?



  • Summary sales reporting and fuzzy matching, mostly.



  • @chubertdev said:

    Summary sales reporting and fuzzy matching, mostly.

    Today I download a pip package called simple-salesforce. I am now able to interface sfdc with python. This is like living in someone wet dream.


  • BINNED

    @Nagesh said:

    someone wet dream.

    Luckily not mine I would add



  • Nothing simple

    from simple_salesforce import Salesforce
    import simplejson as json
    sf = Salesforce(username='nageshk@gmail.com.mysandbox', password='Iaminyourinb0xes', sandbox=True)
    myvar = sf.query("SELECT Id, Email, FirstName, LastName FROM Contact WHERE FirstName = 'Swami'")
    print json.dumps(myvar)



  • @Luhmann said:

    Luckily not mine I would add

    Once you are married, no more wet dreamings for you.

    ETA: Also once you have kid, no more dreams at all.


  • BINNED

    @Nagesh said:

    Once you are married, no more wet dreamings for you.

    ETA: Also once you have kid, no more dreams at all.


    I think you should take your kids to the doctor while I put mine to bed.



  • @Luhmann said:

    I think you should take your kids to the doctor while I put mine to bed.

    Why are you forcing them to sleep? I am not understanding. In India we let kid sleep when he feel like sleeping, unless he goes to school. How old is the kid?


Log in to reply