Null in transport type and missed locations in Resrobot
Hi!
We got two main issues related to Resrobot.
The first one:
Sometimes we receiving null value for RedirectedTicket in TRANSPORT_TYPE
From "https://api.resrobot.se/v2/trip?key=?&originId=...
It cause exceptions on one of our systems:
EXCEPTION]
javax.servlet.ServletException: javax.ejb.EJBException: ASJ.ejb.005044 (Failed in component: sj.se/trip~ear) Exception raised from invocation of public se.sj.trip.app.ejb.redirectservice.RedirectReturnObject se.sj.trip.app.ejb.redirectservice.RedirectService.redirectTicket(se.sj.trip.app.ejb.model.RedirectedTicket) method on bean instance se.sj.trip.app.ejb.redirectservice.RedirectService@6931f8d3 for bean sj.se/trip~ear*annotation|sj.se~trip~ejb~ejbjar.jar*annotation|RedirectService in application sj.se/trip~ear.; nested exception is: java.lang.RuntimeException: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("TRIP"."CONNECTION"."TRANSPORT_TYPE
Could you check why it can happen? We shouldn’t receive NULL from ResRobot
The second one is that we receiving “location missing or invalid” for correct lacations like Stockholm Zon A
I suppose Stockholm Zon A should have id: 740001317
Could you assist with solving mentioned problems?
Hi Andrei
Can you give some more information about issue number one? When I make a request to resrobot reseplanerare api there is no null values in the response. So can you give an example where the response is null?
Stockholm Zon A is only used when creating tickets in sj.se or another sell channel. Resrobot travel planner and our api's do not use "Stockholm zone a" or other similar zone stops.
What are you trying to do with Stockholm Zon A? If you are trying to map a trip to a ticket you could use Stockholm Centralstation instead of Stockholm Zon A because you don't know the final destination the traveler want to go to.
Best regards
Daniel Törbacka
Unfortunately no, I wasn't able to reproduce it on test environment but I still see that it reproduces on prod.
Fro example, I need to provide alternative routes to person with final destination Stockholm Zon A or with connection in Stockholm Zon A.
Hi Andrei
There is no good alternative in resrobot for "stockholm zon a" and its hard to suggest an alternative route without an example to talk about.
Depending on what you are trying to accomplish there is some different alternative you could use.
If you are trying to map a ticket to a route and the person is travelling with train, you could use Stockholm centralstation. For example if the person is travelling from Göteborg centralstation to Stockholm zone A you have to pass though Stockholm centralstation. Then you can give trip suggestions from Göteborg centralstation to Stockholm centralstation.
If the person is travelling with bus to Stockholm you could use Stockholm cityterminal and you could give trip suggestions to cityterminal instead of stockholm zone a.
Please can you explain some more what you are trying to accomplish and give some more informations about your problem. I'm just guessing right now.
Best regards
Daniel