Serious Error

Pinnacle 21 Support Define.xml
1

Hi Toni,

I assume that there is something wrong in your original file and MS Excel auto-corrects it. For example, corrupted cells or other issue with format.

Kind Regards,

Sergiy

2

Hi everyone,

I created an small SAS program to modify a custom excel format into Pinnacle compatible one. When I try to enter the excel to create a define.xml I get the following crash error

[RxCachedThreadScheduler-1] ERROR org.opencdisc.define.Connector - Unexpected exception acting on control event
java.lang.NullPointerException
at org.opencdisc.define.DefineExcelTemplateParser.getCellString(DefineExcelTemplateParser.java:482) ~[define-generator-1.1.7.jar:?]
at org.opencdisc.define.DefineExcelTemplateParser.getNonEmptyRows(DefineExcelTemplateParser.java:490) ~[define-generator-1.1.7.jar:?]
at org.opencdisc.define.DefineExcelTemplateParser.parse(DefineExcelTemplateParser.java:75) ~[define-generator-1.1.7.jar:?]
at org.opencdisc.define.Connector$1.start(Connector.java:166) ~[define-generator-1.1.7.jar:?]
at org.opencdisc.define.Connector$1.onNext(Connector.java:61) [define-generator-1.1.7.jar:?]
at org.opencdisc.define.Connector$1.onNext(Connector.java:45) [define-generator-1.1.7.jar:?]
at rx.Observable$35.onNext(Observable.java:7439) [rxjava-1.0.7.jar:1.0.7]
at rx.observers.SafeSubscriber.onNext(SafeSubscriber.java:130) [rxjava-1.0.7.jar:1.0.7]
at rx.internal.operators.NotificationLite.accept(NotificationLite.java:150) [rxjava-1.0.7.jar:1.0.7]
at rx.internal.operators.OperatorObserveOn$ObserveOnSubscriber.pollQueue(OperatorObserveOn.java:191) [rxjava-1.0.7.jar:1.0.7]
at rx.internal.operators.OperatorObserveOn$ObserveOnSubscriber.access$000(OperatorObserveOn.java:65) [rxjava-1.0.7.jar:1.0.7]
at rx.internal.operators.OperatorObserveOn$ObserveOnSubscriber$2.call(OperatorObserveOn.java:155) [rxjava-1.0.7.jar:1.0.7]
at rx.internal.schedulers.ScheduledAction.run(ScheduledAction.java:47) [rxjava-1.0.7.jar:1.0.7]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.7.0_45]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.7.0_45]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) [?:1.7.0_45]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [?:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.7.0_45]
at java.lang.Thread.run(Unknown Source) [?:1.7.0_45]

I’m not able to identify the issue, furthermore, when I open the excel and click save botton, if I try to use pinnacle again it works. So it’s only crashing if I not open and store as previous step.

Any clue to fix the issue?

Kind regards,

Toni