D
D
DrSterN2021-05-17 06:37:43
PostgreSQL
DrSterN, 2021-05-17 06:37:43

Why did reports break after migrating 1C from mssql to postgresql?

Good day, this is the situation. We decided to migrate from mssql 2019 to postgresql 12.5. We unloaded the database into dt c ms and loaded it into pg. Everything works as it should, but at the same time, the rendering of tabular reports is broken, the report is dispersed as you like, but not as it should. on ms the same report works correctly. DB 30 GB. Poke where to dig with regards to this problem, how to fix these reports? Self-written reports, receivables, daily finances.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin, 2021-05-17
@DrSterN

Self-written reports, receivables, daily finances.

Nu the old problem is that in mssql and postgresql ordering by reference occurs in different ways ... I.e. the same queries may be returned with different ordering.
Edit reports, requests)

D
Dmitry, 2021-05-17
@q2digger

I immediately warn you, I don’t rummage in 1C, at all, just thinking aloud.
there could be some views or procedures in the database itself, most likely stuffed there manually. And in reports of an appeal to these views.
When they moved, they didn't pick up. Look somewhere in these reports what they call there and check with handles in the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question