traccar implementation

[Mohamed Jamel]

Hi,

I would like to create my own gtfs realtime feed. i  already have a gps that connect to my traccar server a beside  my gtfs feed.

so i want to implement it to transitime  . and create my gtfs rt feed.

[Óg Crudden]

Hi Mohamed,

Are you going to set up your own transitclock instance?

Cheers,

Sean.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/f0eda14e-eac1-44f9-bb1c-9035e473f152o%40googlegroups.com.

[Mohamed Jamel]

Hi,

yes i would like to set up my own transitclock instance

best regards

[Mohamed Jamel]

 

Hi,

 

So I tried transitclockdocker and it's working fine. But I couldn't add my traccar information to it.

   best regards  

 

 

[Óg Crudden]

Hi Mohamed,

This line has a list of optional modules that can be run in TheTransitClock. In MPK it reads the data from a GTFS vehicle positions feed which is done with the GtfsRealtimeModule

https://github.com/TheTransitClock/transitclockDocker/blob/11a3f8861b7999c7c231606a101e8dcdb4491adf/config/transitclock.properties#L80  

You need to replace this module with the org.transitclock.custom.traccar.TraccarAVLModule module and then set the following parameters in the transitclock.properties file.

transitclock.avl.traccar.email

transitclock.avl.traccar.password

transitclock.avl.traccar.baseurl

You will then need to turn on the autoassigner as there will be no assignment information in your traccar feed. This can be done by setting this value in transitclock.properties.

https://github.com/TheTransitClock/transitclockDocker/blob/11a3f8861b7999c7c231606a101e8dcdb4491adf/config/transitclock.properties#L1

Hope this helps.

Cheers,

Sean.

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/23f37d92-7037-4578-b710-a154d6804bcao%40googlegroups.com.

[Mohamed Jamel]

 

Hi Óg,

i added those lines in my transitclock.proerties file :

transitclock.modules.optionalModulesList=org.transitclock.custom.traccar.TraccarAVLModule

transitclock.avl.traccar.email=email

transitclock.avl.traccar.password=pass

transitclock.avl.traccar.baseurl=http://@traccar:port    

and i changed autoassigned to true 

transitclock.autoBlockAssigner.autoAssignerEnabled=true

but unfortunately when i visit transitclock's api vehicles i don't find any vehicle

  

   

 

 

 

[Óg Crudden]

Hi Mohamed,

Can you check the avl.log file within the docker container and see if it is giving a reason. I suspect it is these settings that may not be valid for your location.

transitclock.avl.minLongitude=10.725
transitclock.avl.maxLongitude=25.35
transitclock.avl.minLatitude=51.35
transitclock.avl.maxLatitude=55.45

https://github.com/TheTransitClock/transitclockDocker/blob/11a3f8861b7999c7c231606a101e8dcdb4491adf/config/transitclock.properties#L11-L14

Cheers,

Sean.

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/49e510e6-9c0b-4f13-9b28-bb901e782961o%40googlegroups.com.

[Mohamed Jamel]

 

Hi Óg,

 

In my avl log file i didn't find anything useful it's started by 

Started module org.transitclock.avl.GtfsRealtimeModule for agencyId=1

reading file:///C:/Users/Mike/gtfsRealtimeData

read complete

processed 0 reports for feed file:///C:/Users/Mike/gtfsRealtimeData

reading file:///C:/Users/Mike/gtfsRealtimeData

read complete 

And i already fixied minLongitude,maxLongitude,minLatitude,maxLatitude in transitclock.properties

    

     

 

 

[Óg Crudden]

Did you run go.sh after changes to properties?

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/e5bb95d6-dc7f-410b-aa3b-602abbdb7558o%40googlegroups.com.

[Mohamed Jamel]

          yes i did  

 

[Óg Crudden]

Is there any info in core.log?

On Fri, 19 Jun 2020, 18:25 Mohamed Jamel, <khiared...@gmail.com> wrote:

          yes i did  

 

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/2f9395d6-cff8-44a9-8f53-e84b57222ab2o%40googlegroups.com.

[Mohamed Jamel]

 

Hi Óg,

thank you  for helping me. I check my core.log file and it said that traccar url missing /api in the end . so i fixed it  and now i  can see my vehicle as Unassigned Vehicles in the map.

But it get to long to update the vehicle  position.

So is there any configuration to make the update at the moment? 

And how to assign a vehicle to a trip?

   best regards  

  

 

 

[Óg Crudden]

Hi Mohamed,

Glad to hear you are making progress. Are the vehicle positions updating on the map even though they are taking some time?

Cheers,

Sean.

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/22314e32-d6f9-4cc3-9c35-272f60ad0854o%40googlegroups.com.

[Mohamed Jamel]

Hi Óg,

       yes the vehicle positions are updating in the map but they take 3 to 7 minutes to re update 

[Óg Crudden]

Hi Mohamed,

Can you look in avl.log and see how often you are getting an avl update into TheTransitClock? I want to understand if the delay is in the traccar or in the clock.

Cheers,

Sean.

On Mon, Jun 22, 2020 at 12:33 PM Mohamed Jamel <khiared...@gmail.com> wrote:

Hi Óg,

       yes the vehicle positions are updating in the map but they take 3 to 7 minutes to re update 

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/ee654b56-0d46-4e1a-ab61-644176806197o%40googlegroups.com.

[Mohamed Jamel]

Hi Óg,

In my avl.log file there are some errors :

 

1/Error accessing AVL feed using URL=null.

2/Caused by: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.lang.String out of START_OBJECT token

 at [Source: org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$UnCloseableInputStream@7d7f1e31; line: 1, column: 535] (through reference chain: java.util.ArrayList[0]->io.swagger.client.model.Position["network"])

[Óg Crudden]

Hi Mohamed,

Could you send me the avl.log file?

Cheers,

Sean.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/83661b05-5ac8-4308-add5-ec11587e52a0o%40googlegroups.com.

[Mohamed Jamel]

Hi Óg,

  

This is my avl.log file  

[Óg Crudden]

Hi Mohamed,

This seems to be an issue that will need further investigation. The api from traccar may have changed or a recent change to the code in TheTransitClock may have affected this. 

For me to look at this further I would need to test against the traccar api you are using and the GTFS file you are using. 

Cheers,

Sean.

On Mon, Jun 22, 2020 at 1:17 PM Mohamed Jamel <khiared...@gmail.com> wrote:

Hi Óg,

  

This is my avl.log file  

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/e2e9d656-744e-447d-8d6b-5feedb5c6412o%40googlegroups.com.

[Óg Crudden]

Hi Mohamed,

I ran a test against your traccar server and it failed on the old traccar api swagger file. On the latest api swagger file from traccar it seems to work. I will raise an issue on Github and fix.

Cheers,

Sean.

[Mohamed Jamel]

 

Hi Óg,

I think it works . In my avl.log file it update the vehicle  position every 10 second .But in the map it get longer than that .

and another question  i created my gtfs file with static gtfs manager and the shape there was very clear and right but in transitclock the shape was different 

best regards

[Óg Crudden]

Hi Mohamed,

Can you show me an image of the two side by side?

Thanks,

Sean.

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/5c962bd5-f883-412b-864c-c3f223e6027bo%40googlegroups.com.

[Mohamed Jamel]

Hi Óg,

this is transitclock image :

 

and those images from static gtfs manager.

ps: my gtfs feed has 1 route and 48 trips every trip has onward and return journey

   Best regards

[Vicente Pérez]

Hi Mohamed,

GTFSFilePorcessor assumes that bus stops are quite close. I had some similar issue, so I had to add two parameters: maxDistanceBetweenStops and disableSpecialLoopBackToBeginningCase. 

When you load the GTFS file (remember to change the date of the file or to remove previous data) try with different combinations of them. Particularly  try  with a larger number for maxDistanceBetweenStops: more than the distance between the first two stops that looks large.

Best regards

Vicente

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/2e311b4b-5f57-4fcf-b118-7d84268f6461o%40googlegroups.com.

[Mohamed Jamel]

 Hi,

It works. i added  maxDistanceBetweenStops and disableSpecialLoopBackToBeginningCase to import_gtfs.sh file. and voila ! my  shape looks prettier.thank you Vicente for helping .

But I still  wonder how does transitclock assign a vehicle to a  trip cause i have 2 vehicles and it only assigned one .

 Best regards 

[Mohamed Jamel]

Hi Óg, 

 

I hope you are doing great.

So thank to you my transitclock instance works fine in the localhost. But when i use it in the server it telling me 400 bad request

Ps  i have traccar installed in the server  

Best regards

[Óg Crudden]

Hi Mohamed,

Sorry, I do not have enough information on how you have set it up on your server to be of assistance. Is there any information in the tomcat log files? 

Cheers,

Sean.

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/072813e8-9ddc-4e80-a73b-8a168c7c3bc0o%40googlegroups.com.

[Mohamed Jamel]

Hi Óg,

I did  implement  transitclock instance  in an azure VM.i had an error 400 bad request in the api . and it was caused by  a low memory space . so i increase my VM resourse.

and i fixed it.

But i was wondering is there any way to improve the prediction in transitclock cause sometimes there is no predictions or there is no  Vehicles assigned

Best regards 

[Óg Crudden]

Hi Mohamed,

If there are no vehicles assigned this can be because the Auto Assigner is not able to assign them. You have two paths to resolving this. One is to have the assignment provided to the transitclock and the other is to look at changing the configuration options used by the Auto Assigner and see if changing these results in your vehicles being more often assigned. 

Is there any data source where you could get access to the vehicle assignment? If not, then I think the later option is worth you investigating further.

Cheers,

Sean Óg.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/a656f008-ef68-48e4-8858-9c9d3ff753d4o%40googlegroups.com.

[Mohamed Jamel]

   

  Hi Óg,

Thank you for helping i really appreciate it . 

So i will try to change the configuration options of the auto assigner. and i hope i find a better result .

But what do you mean by vehicle assignment data  source 

Best regards 

 

[Óg Crudden]

Hi Mohamed,

In some bus companies the driver signs into the vehicle for their work roster which has a list of trips  that they are meant to run that day. This set of trips is known as a block. If we know the block for the bus then we can assign it correctly while it is running. This data from this sign in is what I am thinking about. Does that make sense?

Cheers,

Sean Óg

--

www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/30dcf9ae-228d-479a-a468-d54aec8cfb9eo%40googlegroups.com.

[Mohamed Jamel]

 

Hi Óg, Okay that make sense.but it's little complicated. the vehicle has a list of trips known as a block. the driver has to signs into the vehicle that has his block.and we need the block to assign the bus correctly . so how i can create this block and what type of data it is (file /api)?  Best regards

[Óg Crudden]

Hi Mohamed,

block_id can be set on the GTFS static file. See link below for more information.

https://developers.google.com/transit/gtfs/reference#stopstxt

Cheers,

Sean Óg.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/013ff515-2d63-491a-ae34-a314d74d7f2ao%40googlegroups.com.

[khiared...@gmail.com]

Hi Óg,

Okay that interesting.So i added block_id into my trips file.and the transitclock'api for the blocks are working fine.

 but nothing change in the Vehicles assignment 

Best regards 

[Óg Crudden]

Hi Mohamed,

There are two sides to this. You need a block id (or trip id) in the GTFS static file but you also need a matching block id (or trip id) in the AVL real time data source.

Traccar does not provide this which is why I asked if you have an alternative AVL data source that has this data?

Hope this helps.

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/d22a5f60-819a-4ffb-a694-96757ea3dc0cn%40googlegroups.com.

[Joshua R Santiago-Ibarra]

Hi,

I've followed the steps into implementing traccar. Yet, I can't get access to it. The program can't is always unauthorized to get the data from traccar. I've checked the passwords are right but it doesn't work.

Thanks,

Joshua

[Óg Crudden]

Hi Joshua,

Where are you seeing the message that it is unauthorized? 

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/bcdaeea3-0f07-4f1f-b80b-732988efbeb8n%40googlegroups.com.

[Joshua R Santiago-Ibarra]

Hi Óg,

In the core.log

[Joshua R Santiago-Ibarra]

Hi Óg,

Thanks for the help in the GitHub issue. It's up and running. I only have one doubt, how do I view the website?

Do I have to start transit clock quick start simultaneously or not?

Thanks for the help

[Joshua R Santiago-Ibarra]

Hi,

I'm having the same problem with the GTFS file. Where did you add maxDistanceBetweenStops and SpecialLoopBack?

Thank you,

[khiared...@gmail.com]

Hi Joshua,

You can add maxDistanceBetweenStops and  SpecialLoopBack at the java command  in the import_gtfs.sh file. 

Best regards

[khiared...@gmail.com]

Hi Óg,

I already added the block_id into my gtfs static file.But actually i don' t have  an alternative AVL data source for traccar .

Is there anything that i can do to provide this data ?

Best regards 

[Óg Crudden]

Hi Mohamed,

The ideal input for TheTransitClock is a GTFS realtime vehicle position feed with assignment information provided in this feed. The Traccar data does not have any assignment information, only positions. So in this case the autoassigner is required, and the appropriate configuration of it needs to be considered.

Hope this helps.

Cheers,

Sean.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/a2ecb1e3-282b-41de-9082-be621ce36a81n%40googlegroups.com.

[khiared...@gmail.com]

Hi Óg,

So how to configure the autoassigner in the transitclock

Best regards  

[Óg Crudden]

Hi Mohamed,

If you search for autoBlockAssigner in the code or in the coreconfig.log file you will see the set of parameters that can be set for the autoassigner. The one to turn it on is 

transitclock.autoBlockAssigner.autoAssignerEnabled

which needs to be set to true. 

If you have issues with assigning vehicles from the first stops of a block or trip you could also run the SchedBasedPredsModule.

Cheers,

Sean.

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/87293f8d-2a69-48a7-a8a3-58405fa61f13n%40googlegroups.com.

[Joshua R Santiago-Ibarra]

Hi Óg,

When I'm running transit clock and the bus matches with a route the following error appears. I've runned the program various times and it's the same error. I have auto assigner enabled

Thanks for the help

[Joshua R Santiago-Ibarra]

java.lang.NullPointerException: null

at org.transitclock.core.RealTimeSchedAdhProcessor.generateEffectiveScheduleDifference(RealTimeSchedAdhProcessor.java:185) ~[Core.jar:na]

at org.transitclock.core.PredictionGeneratorDefaultImpl.generate(PredictionGeneratorDefaultImpl.java:423) ~[Core.jar:na]

at org.transitclock.core.MatchProcessor.processPredictions(MatchProcessor.java:80) ~[Core.jar:na]

at org.transitclock.core.MatchProcessor.generateResultsOfMatch(MatchProcessor.java:200) ~[Core.jar:na]

at org.transitclock.core.AvlProcessor.lowLevelProcessAvlReport(AvlProcessor.java:1425) ~[Core.jar:na]

at org.transitclock.core.AvlProcessor.processAvlReport(AvlProcessor.java:1619) ~[Core.jar:na]

at org.transitclock.avl.AvlClient.run(AvlClient.java:163) ~[Core.jar:na]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_262]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_262]

at java.lang.Thread.run(Thread.java:748) [na:1.8.0_262]

at org.transitclock.utils.threading.NamedThread.run(NamedThread.java:100) [Core.jar:na]

[khiared...@gmail.com]

Hi Óg,

in the transitclock.properties  i found these params:

transitclock.autoBlockAssigner.ignoreAvlAssignments=false

transitclock.autoBlockAssigner.allowableEarlySeconds=1200

transitclock.autoBlockAssigner.allowableLateSeconds=1200

i already  increment the allowableLate/EarlySeconds value and nothing has been changed beside i added 

transitclock.modules.optionalModulesList=org.transitclock.core.schedBasedPreds.SchedBasedPredsModule

some stops has no prediction

Best regards 

[Óg Crudden]

Hi Mohamed,

Not sure I understand what you are asking me in this post. Could you elaborate?

Thanks,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/9edf663d-94cf-4fdf-aa08-1a50508de22fn%40googlegroups.com.

[khiared...@gmail.com]

Hi Óg,

I want to configure the transitclock autoassigner and i don't know how to do it 

Best regards 

[Óg Crudden]

Hi Mohamed,

Are any of your vehicles assigned at any time? Can you see this on the map or in the autoAssigner.log file. 

It is hard to diagnose just by email. 

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/8e1a2c86-72d3-4472-8969-bc70bfb6c552n%40googlegroups.com.

[khiared...@gmail.com]

Hi Óg,

Right now i have 3 vehicles and only one is assigned.But i don't know how it's work cause this morning i checked out and there  were all assigned vehicle  i think in every trip it reassigned 

Best regards 

[Óg Crudden]

Hi Mohamed,

Are the vehicles servicing active trips (on route) or are they waiting to start their trips?

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/94d34562-274e-46a4-aeda-a370abd6a737n%40googlegroups.com.

[khiared...@gmail.com]

Hi Óg,

One is waiting to start the trip and the other is servicing another trip 

Best regards 

[wojciech...@goeuropa.eu]

Hey guys,

i tried adding - maxDistanceBetweenStops 100 and run import_gtfs when logged in to docker but i got:UPDATE 0 in the end of the process.

See the map of schedules, and still a lot of long straight lines.

Am i doing something wrong ?

I don't have disableSpecialLoopBackToBeginningCase anywhere in import_gtfs and my line looks like this:

java -Xmx4g -Dtransitclock.core.agencyId=$AGENCYID -Dtransitclock.configFiles=/usr/local/transitclock/config/transitclock.properties -Dtransitclock.logging.dir=/usr/local/transitclock/logs/ -Dlogback.configurationFile=$TRANSITCLOCK_CORE/transitclock/src/main/resouces/logbackGtfs.xml -cp /usr/local/transitclock/Core.jar org.transitclock.applications.GtfsFileProcessor -gtfsUrl $GTFS_URL  -maxDistanceBetweenStops 100 -maxTravelTimeSegmentLength 100

Regards,

Wojciech

[Óg Crudden]

Hi Wojciech,

The gtfs import failed so there may be more detail in core.log.

Cheers,

Sean.

--
www.thetransitclock.org
---
You received this message because you are subscribed to the Google Groups "TheTransitClock" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thetransitclo...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/4b33710f-c045-438a-a1c4-610ed5c61321n%40googlegroups.com.

[Wojciech Kulesza]

Hi,

here is log immediately after update 0:

root@5e36cee436b0:/usr/local/transitclock/logs/1211/core/2020/11/23# tail -n 100 core.log
  Detail: Key (tripid, starttime, configrev)=(501, 60900, 0) is still referenced from table "trip_scheduledtimeslist".
Error writing GTFS configuration data to db.
org.hibernate.exception.ConstraintViolationException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) ~[Core.jar:na]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) ~[Core.jar:na]
        at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211) ~[Core.jar:na]
        at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1346) ~[Core.jar:na]
        at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389) ~[Core.jar:na]
        at org.transitclock.db.structs.Block.deleteFromRev(Block.java:285) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.actuallyWriteData(DbWriter.java:104) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.write(DbWriter.java:222) ~[Core.jar:na]
        at org.transitclock.gtfs.GtfsData.processData(GtfsData.java:2743) [Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.process(GtfsFileProcessor.java:306) [Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.main(GtfsFileProcessor.java:677) [Core.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "trips" violates foreign key constraint "fk_n5et0p70cwe1dwo4m6lq0k4h0" on table "trip_scheduledtimeslist"
  Detail: Key (tripid, starttime, configrev)=(501, 60900, 0) is still referenced from table "trip_scheduledtimeslist".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366) ~[Core.jar:na]
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[Core.jar:na]
        ... 9 common frames omitted
Exception when writing data to db
org.hibernate.exception.ConstraintViolationException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) ~[Core.jar:na]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) ~[Core.jar:na]
        at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211) ~[Core.jar:na]
        at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1346) ~[Core.jar:na]
        at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389) ~[Core.jar:na]
        at org.transitclock.db.structs.Block.deleteFromRev(Block.java:285) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.actuallyWriteData(DbWriter.java:104) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.write(DbWriter.java:222) ~[Core.jar:na]
        at org.transitclock.gtfs.GtfsData.processData(GtfsData.java:2743) ~[Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.process(GtfsFileProcessor.java:306) [Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.main(GtfsFileProcessor.java:677) [Core.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "trips" violates foreign key constraint "fk_n5et0p70cwe1dwo4m6lq0k4h0" on table "trip_scheduledtimeslist"
  Detail: Key (tripid, starttime, configrev)=(501, 60900, 0) is still referenced from table "trip_scheduledtimeslist".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366) ~[Core.jar:na]
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[Core.jar:na]
        ... 9 common frames omitted
could not execute statement
org.hibernate.exception.ConstraintViolationException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) ~[Core.jar:na]
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) ~[Core.jar:na]
        at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:211) ~[Core.jar:na]
        at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1346) ~[Core.jar:na]
        at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:389) ~[Core.jar:na]
        at org.transitclock.db.structs.Block.deleteFromRev(Block.java:285) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.actuallyWriteData(DbWriter.java:104) ~[Core.jar:na]
        at org.transitclock.gtfs.DbWriter.write(DbWriter.java:222) ~[Core.jar:na]
        at org.transitclock.gtfs.GtfsData.processData(GtfsData.java:2743) ~[Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.process(GtfsFileProcessor.java:306) ~[Core.jar:na]
        at org.transitclock.applications.GtfsFileProcessor.main(GtfsFileProcessor.java:677) ~[Core.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "trips" violates foreign key constraint "fk_n5et0p70cwe1dwo4m6lq0k4h0" on table "trip_scheduledtimeslist"
  Detail: Key (tripid, starttime, configrev)=(501, 60900, 0) is still referenced from table "trip_scheduledtimeslist".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[Core.jar:na]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) ~[Core.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366) ~[Core.jar:na]
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:147) ~[Core.jar:na]
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[Core.jar:na]
        ... 9 common frames omitted
====================================================AvlProcessor processing AvlReport [vehicleId=6, time=11-23-2020 12:59:17.000 CET, location=[52.38586, 16.90274], speed=NaN, heading=NaN, source=This is th, assignmentId=null, assignmentType=UNSET]
No assignment info for vehicleId=6 so trying to assign vehicle without it.
Trying to automatically assign vehicleId=6

Can you advice ?

Wojciech

--

Wojciech Kulesza Właściciel / Owner goEuropa Polska Wojciech Kulesza +48616248682 wojciech...@goeuropa.eu www.goeuropa.eu ul. 28 Czerwca 1956r nr 400 Kiedy przyjedzie autobus? Sprawdż na www.kiedybus.pl

[Óg Crudden]

Hi Wojciech,

Could you create a github issue with this detail and attach the gtfs file?

Thanks,

Sean.

[Wojciech Kulesza]

Yes,

done: https://github.com/TheTransitClock/transitclockDocker/issues/10

[Joshua R Santiago-Ibarra]

Hello, 

I hope you are all in good health. I'm writing because I've been using Transit Clock with Traccar and passing it on to One Bus Away. Some days ago I switched from the 5 device server in Traccar to the 20 device server and from that moment I haven't been able to see the GPS in the transit clock. 

The following shows the Avl file. And the core file, the last logs on the core.log are from me checking if the GPS is visible on the map. I only have one vehicle en route. 

[Óg Crudden]

Hi Joshua,

From the avl log file it looks like the permissions are not set on traccar. The user you use for TheTransitClock to talk to traccar needs admin access to traccar.

Cheers,

Sean.

To view this discussion on the web visit https://groups.google.com/d/msgid/thetransitclock/61bd0424-5145-4550-a7e7-3ae912a63b67n%40googlegroups.com.