Bug 908346

Summary:	WARN log is generated by API call errata.create()
Product:	Red Hat Satellite 5	Reporter:	Martin Korbel <mkorbel>
Component:	API	Assignee:	Tomas Lestach <tlestach>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Martin Korbel <mkorbel>
Severity:	low	Docs Contact:
Priority:	low
Version:	550	CC:	cperry, dyordano
Target Milestone:	---	Keywords:	Regression
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:	905092	Environment:
Last Closed:	2013-10-01 21:53:42 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	924232

Description Martin Korbel 2013-02-06 13:31:48 UTC

Same problem as bug905092

Description of problem:

WARN log is generated  to catalina.out by  API call errata.create()

Version-Release number of selected component (if applicable):
Satellite 550

How reproducible:
100%

Steps to Reproduce:
1. Create Custom Software Channel
2. Push a package(s) to the channel.
3. Create a Errata with API call errata.crate but leave the 'notes' parameter empty in struct errataInfo.

array:

struct - errata info

    string "synopsis"
    string "advisory_name"
    int "advisory_release"
    string "advisory_type" 
    string "product"
    string "errataFrom"
    string "topic"
    string "description"
    string "references"
    string "notes"
    string "solution"


----
Actual results:
The following log is generated in catalina.out

WARN  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object com.redhat.rhn.domain.errata.impl.UnpublishedErrata is setting empty string notes

Expected results:
No logs.

Comment 1 Tomas Lestach 2013-02-06 14:27:27 UTC

We already have the fix in upstream ...

spacewalk.git: 709e630a2906d470bf9a4aa8c3ef1fd27d8dee04

Comment 3 Martin Korbel 2013-09-25 09:05:32 UTC

VERIFIED on spacewalk-java-2.0.2-39.el6sat (Satellite-5.6.0-RHEL6-re20130917.0)
REPRODUCED on spacewalk-java-1.7.54-119.el6sat (Satellite-5.5.0)
FIXED in spacewalk-java-1.8.64-1

Sat5.4.1 is OK (spacewalk-java-1.2.39-133.el6sat).

> python
>>> import xmlrpclib
>>> client = xmlrpclib.Server('http://localhost/rpc/api', verbose=0)
>>> key = client.auth.login('admin','xxx')
>>> client.errata.create(key,{'synopsis':'TEST9:2013','advisory_name':'TEST9:2013','advisory_release':1,'advisory_type':'Bug Fix Advisory','product':'XXX','topic':'XXX','description':'XXX','references':'','solution':'XXX'},[],[],[],0,[])
> grep  "com.redhat.rhn.domain.errata.impl.UnpublishedErrata" /var/log/tomcat6/catalina.out

Sat 5.6.0 and Sat 5.4.1:
<empty>

Sat 5.5.0:
2013-09-25 04:50:40,572 [TP-Processor3] WARN  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object com.redhat.rhn.domain.errata.impl.UnpublishedErrata is setting empty string notes
2013-09-25 04:50:40,581 [TP-Processor3] WARN  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object com.redhat.rhn.domain.errata.impl.UnpublishedErrata is setting empty string refersTo

Comment 4 Clifford Perry 2013-10-01 21:53:42 UTC

Satellite 5.6 has been released. This bug was tracked under the release.  

This bug was either VERIFIED or RELEASE_PENDING (re-verified prior shortly
before release). 

Moving to CLOSED CURRENT_RELEASE. 

Text from Upgrade Erratum follows:

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHEA-2013-1395.html