tag:blogger.com,1999:blog-2958388740695195064.post7274253422042319671..comments2024-03-05T10:48:20.013+02:00Comments on IBM BPM administration for Dummies: How to open FileNet Global Configuration Data without any accounts (Part1)Vladlen Litvinovhttp://www.blogger.com/profile/01018388067571296920noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2958388740695195064.post-10133773262703041252015-05-14T09:00:01.596+02:002015-05-14T09:00:01.596+02:00Thanks, Bayu Thanks, Bayu Vladlen Litvinovhttps://www.blogger.com/profile/01018388067571296920noreply@blogger.comtag:blogger.com,1999:blog-2958388740695195064.post-2549330112073631662015-05-14T01:38:56.831+02:002015-05-14T01:38:56.831+02:00Just want to add IF the database is DB2
For export...Just want to add IF the database is DB2<br />For export: use this command <br />export to gcd.xml of del lobfile result_lob_modified select gcd_blob from fngcd where epoch_id= last_epoch_id<br />Duplicate the result_lob_modified file and After replacing the SecurityDescriptor<br />Export with this command<br />import from gcd.xml of del lobs from result_lob_modified.001.lob modified by lobsinfile insert into fngcd_blank<br />Last: do the update from fngcd_blank to fngcd table.Anonymoushttps://www.blogger.com/profile/04377479158428686115noreply@blogger.comtag:blogger.com,1999:blog-2958388740695195064.post-48272210673458617032015-05-14T01:35:07.683+02:002015-05-14T01:35:07.683+02:00Thanks for the tricks.
I've tried successfully...Thanks for the tricks.<br />I've tried successfully and it save my days of waiting time for the PMR.<br /><br />Actually no need to truncate because we export only the last_epoch_id row, so we can update the last row only. First, we must copy FNGCD table to EMPTY FNGCD table, Import to the new and update via SQL statement the gcd_blob field only. It works!.<br /><br />Thanks a lot.Anonymoushttps://www.blogger.com/profile/04377479158428686115noreply@blogger.comtag:blogger.com,1999:blog-2958388740695195064.post-83628416626798771432014-11-04T12:54:13.718+02:002014-11-04T12:54:13.718+02:00I've forgotten this moment. Truncate the table...I've forgotten this moment. Truncate the table FNGCD because you load the same configuration into it and you have index error.Vladlen Litvinovhttps://www.blogger.com/profile/01018388067571296920noreply@blogger.comtag:blogger.com,1999:blog-2958388740695195064.post-16715730353633759052014-11-04T12:19:00.689+02:002014-11-04T12:19:00.689+02:00Hi, I following your tutorial above, but in the st...Hi, I following your tutorial above, but in the step of importing gcd,xml back into the database, I got error start from Invalid time format, Unexpected EOF encountered in BCP data-file, text column data incomplete, cannot insert duplicate key row in object 'dbo.FNGCD' with unique index 'I_FNGCD01'. the duplicate key value is (0), and the statement has been terminated. Do you know how to solve it?Timmynoreply@blogger.com