based on this debug i can see a couple of things.

1. you didnt update your report/node files based on the update section in the release notes
2. i cant see the error you mentioned in the logs

does the error comes from puppet or foreman?

1. I did update both file maybe you see it because foreman is installed as a standalone and not as a puppetmaster
2. The error comes from puppet agents when running "puppet agent -t"

My puppet version is 2.7.18

Perhaps the error is coming from the puppet master itself. Do you have a shared database between Puppet (puppet.conf) and Foreman (/etc/foreman/database.yml)? If so, this is no longer supported from 1.2 onwards, so you need to separate them.

Yes, the error comes from puppet master and I do have 1 database for both,

I created a new database for foreman dumped the old database to new one and now I need to initialize the puppetmaster's database again hope it'll work

Thank you very much

Problem solved

Note: I upgraded from 1.1 to 1.3 and the change about the databases only appears on 1.2 upgrade guides