t Toni
on

 

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

 

Forums: Define.xml

s Sergiy
on April 4, 2019

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

Want a demo?

Let’s Talk.

We're eager to share and ready to listen.

Cookie Policy

Pinnacle 21 uses cookies to make our site easier for you to use. By continuing to use this website, you agree to our use of cookies. For more info visit our Privacy Policy.