Skip to Content
Odoo Meniu
  • Autentificare
  • Try it free
  • Aplicații
    Finanțe
    • Contabilitate
    • Facturare
    • Cheltuieli
    • Spreadsheet (BI)
    • Documente
    • Semn
    Vânzări
    • CRM
    • Vânzări
    • POS Shop
    • POS Restaurant
    • Abonamente
    • Închiriere
    Site-uri web
    • Constructor de site-uri
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Lanț Aprovizionare
    • Inventar
    • Producție
    • PLM
    • Achiziție
    • Maintenance
    • Calitate
    Resurse Umane
    • Angajați
    • Recrutare
    • Time Off
    • Evaluări
    • Referințe
    • Flotă
    Marketing
    • Social Marketing
    • Marketing prin email
    • SMS Marketing
    • Evenimente
    • Automatizare marketing
    • Sondaje
    Servicii
    • Proiect
    • Foi de pontaj
    • Servicii de teren
    • Centru de asistență
    • Planificare
    • Programări
    Productivitate
    • Discuss
    • Aprobări
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Aplicații Terțe Odoo Studio Platforma Odoo Cloud
  • Industrii
    Retail
    • Book Store
    • Magazin de îmbrăcăminte
    • Magazin de Mobilă
    • Magazin alimentar
    • Magazin de materiale de construcții
    • Magazin de jucării
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Distribuitor de băuturi
    • Hotel
    Proprietate imobiliara
    • Real Estate Agency
    • Firmă de Arhitectură
    • Construcție
    • Estate Managament
    • Grădinărit
    • Asociația Proprietarilor de Proprietăți
    Consultanta
    • Firma de Contabilitate
    • Partener Odoo
    • Agenție de marketing
    • Law firm
    • Atragere de talente
    • Audit & Certification
    Producție
    • Textil
    • Metal
    • Mobilier
    • Mâncare
    • Brewery
    • Cadouri corporate
    Health & Fitness
    • Club Sportiv
    • Magazin de ochelari
    • Centru de Fitness
    • Wellness Practitioners
    • Farmacie
    • Salon de coafură
    Trades
    • Handyman
    • IT Hardware and Support
    • Asigurare socială de stat
    • Cizmar
    • Servicii de curățenie
    • HVAC Services
    Altele
    • Organizație nonprofit
    • Agenție de Mediu
    • Închiriere panouri publicitare
    • Fotografie
    • Închiriere biciclete
    • Asigurare socială
    Browse all Industries
  • Comunitate
    Învăță
    • Tutorials
    • Documentație
    • Certificări
    • Instruire
    • Blog
    • Podcast
    Empower Education
    • Program Educațional
    • Scale Up! Business Game
    • Visit Odoo
    Obține Software-ul
    • Descărcare
    • Compară Edițiile
    • Lansări
    Colaborați
    • Github
    • Forum
    • Evenimente
    • Translations
    • Devino Partener
    • Services for Partners
    • Înregistrează-ți Firma de Contabilitate
    Obține Servicii
    • Găsește un Partener
    • Găsiți un contabil
    • Meet an advisor
    • Servicii de Implementare
    • Referințe ale clienților
    • Suport
    • Actualizări
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obține un demo
  • Prețuri
  • Ajutor

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Contabilitate
  • Inventar
  • PoS
  • Proiect
  • MRP
All apps
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Suport

Integrity error while installing hr_timesheet module

Abonare

Primiți o notificare când există activitate la acestă postare

Această întrebare a fost marcată
modulehr_timesheet
2 Răspunsuri
9535 Vizualizări
Imagine profil
Jasim

Hi, When i try to install hr_timesheet module, on OE 7, latest edition (tried with many versions from April onwards ) I am getting an error

Integrity Error

The operation cannot be completed, probably due to the following: - deletion: you may be trying to delete a record while other records still reference it - creation/update: a mandatory field is not correctly set

[object with reference: name - name]

The log @ openerp shows like this

2013-05-16 17:13:12,190 15857 ERROR zsenda openerp.netsvc: Integrity Error
The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still refer                                                                                        ence it
- creation/update: a mandatory field is not correctly set

[object with reference: name - name]
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_r                                                                                        pc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626,                                                                                         in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 188, in execute_k                                                                                        w
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 172, in wrapper
    netsvc.abort_response(1, _('Integrity Error'), 'warning', msg)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 71, in abort_respo                                                                                        nse
    raise openerp.osv.osv.except_osv(description, details)
except_osv: ('Integrity Error', 'The operation cannot be completed, probably due                                                                                         to the following:\n- deletion: you may be trying to delete a record while other                                                                                         records still reference it\n- creation/update: a mandatory field is not correct                                                                                        ly set\n\n[object with reference: name - name]')
2013-05-16 17:13:12,191 15857 INFO zsenda werkzeug: 192.168.1.190 - - [16/May/20                                                                                        13 17:13:12] "POST /web/dataset/call_button HTTP/1.1" 200 -

The error is not raising when I create a new database and install the hr_timesheet at first. I have tried all these

a. Update the addon codes and upgraded modules which is required for hr_timesheet b. Deleted hr_timesheet (after some sql hacks) and replaced with latest repository module and tried to install it again.

DELETE FROM ir_model_constraint WHERE module = 216;
DELETE FROM ir_model_relation WHERE module = 216;
ALTER TABLE hr_employee DROP COLUMN uom_id, DROP COLUMN journal_id, DROP COLUMN product_id;
DROP TABLE IF EXISTS hr_analytic_timesheet CASCADE;
ALTER TABLE account_analytic_account DROP COLUMN use_timesheets;
DROP TABLE IF EXISTS hr_analytical_timesheet_employee CASCADE;
DROP TABLE IF EXISTS hr_analytical_timesheet_users CASCADE;
DROP TABLE IF EXISTS hr_sign_out_project CASCADE;
DROP TABLE IF EXISTS hr_sign_in_project CASCADE;

c. Backing up of database and restored as new database and tried to install the module again. It also have the same effect (integrity error)

The modules I have installed so far

process
account_cancel
account_voucher
purchase
web_view_editor
hr_payroll
base_import
stock
account_payment
l10n_in_hr_payroll
web_kanban
hr
account_asset
account_accountant
procurement
base_action_rule
web_graph
board
product
base_status
web_diagram
hr_attendance
web_gantt
sale_stock
account_followup
hr_expense
warning
web_tests
web_calendar
web
project
account_chart
sale_crm
hr_payroll_account
account
base_setup
auth_signup
l10n_in
edi
crm
hr_evaluation
decimal_precision
web_shortcuts
sale
analytic
hr_holidays
share
survey
base
mail
email_template
fetchmail
hr_contract
base_calendar
resource
1
Imagine profil
Abandonează
Imagine profil
Pedro Arroyo
Cel mai bun răspuns

borro el empleado administrador? al parecer necesita un registro en la tabla hr_employee con id 1. Intente ingresarlo en la tabla hr_employee con id 1 y el campo active en false.

saludos.

0
Imagine profil
Abandonează
Imagine profil
Jasim
Autor Cel mai bun răspuns

To jsut hack it out, just open hr_timesheet_data.xml and comment out like this

<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data noupdate="1">
      <!---
        <record id="analytic_journal" model="account.analytic.journal">
            <field name="code">TS</field>
            <field name="name">Timesheet Journal</field>
            <field name="type">general</field>
        </record>

        <record id="hr.employee" model="hr.employee">
            <field name="journal_id" ref="analytic_journal"/>
        </record>
      -->
    </data>
</openerp>

Then installation of module will be done smoothly.

Later, Goto Accounting >> Analytic Accounting > Analytic Journals Create a new Analytic Accounting Journal with Journal Name "Timesheet Journal" ,Journal Code "TS", and Type "General"

Later Goto "Human Resources" > "Employees" Take each employee and goto "HR Settings" and put Analytic Journal to "Timesheet Journal" and make sure the product should be selected which you are timely billing like "Time based Software Development / Service"

0
Imagine profil
Abandonează
Santiago

This looks like a work around. I have the same problem, and I wonder if the root cause is a bug in the software or a problem with my database

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te
Related Posts Răspunsuri Vizualizări Activitate
Error when importing module Product Bidding In ECommerce in odoo 17
module
Imagine profil
Imagine profil
1
iul. 24
2580
Missing required value for the field 'Model' (model_id)
module
Imagine profil
Imagine profil
1
ian. 24
6455
View newly installed Module
module
Imagine profil
Imagine profil
Imagine profil
2
mar. 23
3522
How to check for installed modules from my __init__.py?
module
Imagine profil
Imagine profil
3
iun. 20
11396
Helpdesk Module
module
Imagine profil
Imagine profil
Imagine profil
2
mar. 20
9991
Comunitate
  • Tutorials
  • Documentație
  • Forum
Open Source
  • Descărcare
  • Github
  • Runbot
  • Translations
Servicii
  • Hosting Odoo.sh
  • Suport
  • Actualizare
  • Custom Developments
  • Educație
  • Găsiți un contabil
  • Găsește un Partener
  • Devino Partener
Despre Noi
  • Compania noastră
  • Active de marcă
  • Contactați-ne
  • Locuri de muncă
  • Evenimente
  • Podcast
  • Blog
  • Clienți
  • Aspecte juridice • Confidențialitate
  • Securitate
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo este o suită de aplicații de afaceri open source care acoperă toate nevoile companiei dvs.: CRM, comerț electronic, contabilitate, inventar, punct de vânzare, management de proiect etc.

Propunerea de valoare unică a Odoo este să fie în același timp foarte ușor de utilizat și complet integrat.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now