Skip to main content
D
DPK1-Visitor
1-Visitor
September 29, 2014
Question

OOTB loader utility LoadFromFile failing to load the Part structure....

  • September 29, 2014
  • 6 replies
  • 3043 views

Dear All,

Hope everyone doing well,

I am using Windchill OOTB loader (Load FromFile) to create part structure, I was about to finish the loading, unfotunately the loader is getting failed the error shown in the log is like..

wt.system.out wcadmin - All objects were imported successfully.

wt.system.out wcadmin - java.lang.NullPointerException

wt.system.out wcadmin -at wt.part.StandardWTPartService$UsageLinkCommitListener.finishTransaction(StandardWTPartService.java:379)
wt.system.out wcadmin -at wt.pom.TransactionManager$FinishTransactionListener.fire(TransactionManager.java:1518)

...and lot more

Its very strange that inbetween, the loader is failing to generate the links and showing 'All Objects were imported successfully' but actually nothing is in.

Did anyone faced the same issue before, it will be appriciated to help me out in this.

Thank you

6 replies

H
hvaradharajan1-Visitor
1-Visitor
September 30, 2014

Hi,

I hope that you are following the proper sequence of loading, i.e., all child parts first, then all next higher level parents, then only the next level parents..and so on.

This issue is specific and it cannot be diagonised with this Method server log alone.

I suggest you set the property necessary for verbose Method server Log, and restart Method Server and check the issue again, you will have more specific team.

Thanks

Hari

D
DPK1-VisitorAuthor
1-Visitor
September 30, 2014

Hi Hari,

Thanks for your kind interest, I checked the logs after setting the property values for the verbose, its simlar to what i was getting at the begining when i started the loading (Everything was OK).

For the sequence i'll say that every part is in the Windchill, however as per my understanding, it does not matter which link is being created first, Let me know if i am wrong.

I have attached the logs after activating the verbose.

Thanks

BenPerry
BenPerry15-Moonstone
15-Moonstone
September 30, 2014

I am curious why you are not using the "Import from Spreadsheet" functionality in the UI of Windchill?

D
DPK1-VisitorAuthor
1-Visitor
September 30, 2014

Hi Ben,

I am not sure but there are some custom attributes those may not be populated if you use OOTB handler to create the structure.

This could be the reason why PTC's partner suggested us this procedure.

Now the problem is i am stuck here, it is not moving ahead.

Please suggest somthing if you have any idea.

Thanks

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
September 30, 2014

You can use "Import from Spreadsheet", like Ben said, also with custom attributes.

I can't give you our model, because it's in Italian, but you can add more column at the end of standard Execl loader, using you IBA attributes

Marco
D
DPK1-VisitorAuthor
1-Visitor
October 1, 2014

Thanks Ben, I will try that once.

I have a doubt now, if it is not working with LoadFromFile then how come will it work with others because ultimately we are going to use Import/Export functionality of Windchill as i am using it through Windchill shell.

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
October 1, 2014

This is the article from PTC TS.

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS185557&lang=en

Marco
D
DPK1-VisitorAuthor
1-Visitor
October 1, 2014

Thank You Marco for this valuable inforamtion,

It seems like with my current approach it is not writing anything to Database tables, Is there some limitation of space also in the database or is it used to increase as we write anything (sothing like Incremental growth).

And also what is the use of Transaction logs of the Database, in my case those are huge and occupied more space than Windchill vaults, Shall I delete them or not.

Terms & ConditionsAccessibility statement