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.
-
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.
-
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
-
but a salesforce WTF
Doesn't surprise me. The best solution to any SFDC problem is to burn it.
-
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.
-
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)
-
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.
-
-
Am I the only one here with an app on AppExchange?
-
-
Summary sales reporting and fuzzy matching, mostly.
-
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.
-
-
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)
-
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.
-
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.
-
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?